Create Custom Actions

In an application you develop with Kuika, you can create custom actions and use these actions on your screens. From the left menu of the Datasources module, you can view the data sources, actions and tables in the application you have developed, and add new data sources, actions and tables.

1. After logging in to the Kuika platform, open the project you will work on from the “Apps” screen.
2. In the “Datasources” (1) module, click on the “+” icon next to the “Actions” title on the left side.

3. Select “New SQL Action” from the menu that opens.
   

If you want to create a new Custom Action in the Actions sub-panel, click on New SQL Action. If you want to create a new folder and create Custom Actions under this folder, click on New Folder and name and create your folder.

In an example scenario, let's say you want to create an action that lists the departments in the personnel list. Before creating this action, you need to create a table named “Department”. You can find detailed information about table creation in our content.

4. Create a custom action named “Select Department List” to list the departments in your application.
5. Write the SQL query required for the listing in SQL Editor. The query is created automatically for tables on the add query screen.
6. To add a table-specific automatic query, click on the three dots next to the table name in the left menu. Kuika allows you to automatically add and modify “Select”, “Update” and “Delete” queries.
7. You can use the following query to list the departments with the Select Department List special action:

Copyselect * from Department  WHERE DepartmentName LIKE @searchFor  OR @searchFor is null OR @searchFor = ''  ORDER BY DepartmentName

8. After writing the query, test your query with the “TEST” button in the upper right corner and then create the custom action by clicking the “CREATE” button.
9. You can view the action you created in the left panel, then edit, rename and delete it.
10. To edit the action, hover over the action and click on the three dots that appear.

11. Then select “Edit”.
12. On the screen that opens, you can edit the existing SQL queries and update them by clicking on the “Update” button on the top right.
13. Also, if you want to delete the action, click on the “Delete” option in the drop-down menu and complete the process.
    

Custom actions used in projects cannot be deleted without removing them from the modules or processes they are associated with and an error message may be displayed in this case.

In an application developed with Kuika, you can increase the functionality of your application by creating custom actions. You can use the “Custom Actions” panel in the “UI Design” module or the “Actions” section in the “Datasources” module to create these actions.

Open the Custom Actions panel and select “SQL Action”.

1. Action Naming Field
   • You can add or update the action name in the “SQL Actions Name” field. You can use English alphabet characters and “-” and “_” signs for naming.
2. Using SQL Editor Panel in Full Screensome text
   • By making the SQL Editor panel full screen, you can work in a larger area or use it in standard size.
3. Writing a Query Using SQL Editorsome text
   • You can create an action by typing the SQL query for the custom action in the SQL Editor field. Kuika allows you to quickly add basic queries such as “Select”, “Save” and “Delete”.

3.1. Add Select Query: It is used to select records in the table and list them according to certain criteria. For example, a query such as “SELECT * FROM table_name” is created.

3.2. Add Select By Id Query: It is used to select a single record in the table according to a specific ID. For example, “SELECT * FROM table_name WHERE id = certain_id”.

3.3. Add Save Query: It is used to add a new record to the database or update an existing record. First, the existence of the existing record is checked with the “Update” query, then the new data is updated or inserted. If there is no record, the “Insert Into” command is activated and a new record is created in the data table.

3.4. Add Delete Query: It is used to delete a specific record in the database. For example, “DELETE FROM table_name WHERE condition expression”.

3.5. Add Search By Keyword Query: It is used to search the data in the table by a specific keyword. For example, “SELECT * FROM table_name WHERE column_name LIKE ‘%keyword%’”.

3.6. Add Search With Pagination Query: Used to search records by keyword and split the results into pages. Pagination is done with LIMIT and OFFSET parameters. For example, “SELECT * FROM table_name WHERE column_name LIKE ‘%key_keyword%’ LIMIT page_size OFFSET start”

4. Building SQL Queries with AI Assistant

You can get help from an AI Assistant when writing SQL queries. Click on the "Generate with AI" button and select the data table from the Select Box. Enter a command that describes the query you want to generate. For example, "I need a query to delete items". The AI will generate the query and you can copy and paste it into SQL Editor.

5. Adding Queries to SQL Editor

You can easily add AI generated queries by copying them to the SQL Editor area.

6. Query Result Parameter Panel

You can view the parameters of SQL queries in the Parameter Panel with the on/off button on the top right. The panel is dynamically updated according to the parameters of your action.

7. Testing SQL Queries

You can test SQL queries with the "TEST" button.

After completing all operations, you can finish the custom action creation process by clicking the “CREATE” (8) button.

On the Kuika platform, you can define a variable using the “DECLARE” command in the SQL Editor. This command allows you to specify the name of a variable, its data type and, if necessary, its initial value.

General DECLARE Format

DECLARE @variable_name data_type;

• Here, a variable named @variable_name is declared with the specified data_type. data_type is the SQL data type (for example, nvarchar, int, bit, etc.).

Value Assignment Methods

There are two ways to assign a value to a variable:

1. SELECT Assignment:

SELECT @variable = değer FROM table_name;

2. Assignment with SET:

SET @variable = değer;

Example 1:

DECLARE @top1Product nvarchar(256);SELECT TOP 1 @top1Product = productName FROM table_name;

• In this example, a variable named @top1Product is declared and the first product name from table_name is assigned to this variable.

Example 2:

DECLARE @rowCount int;SET @rowCount = (SELECT COUNT(Id) FROM table_name);

• In this example, a variable named @rowCount is defined and the total number of rows in table_name is assigned to this variable.

DECLARE Usage on Kuika Platform

On the Kuika platform, you can manually type the “DECLARE” command in the SQL Editor or you can get support from the Artificial Intelligence Assistant.

By activating the “Generate with AI” switch, you can enter a command by specifying the relevant table in the Search Box field. For example:

• "I want to list only active departments, write a DECLARE command about it ”. The AI will automatically generate the relevant DECLARE function.

In this way, you can create your query quickly and easily.