In Kuika, you can create custom actions and integrate them into your screens. In the Datasources module, you can view and manage existing data sources, actions, and tables.

Steps:

1. Log in to the Kuika platform and open your project from the Apps screen.
2. Open the Datasources module from the top menu.
3. In the Sources section of the left panel, expand the Managed DB heading.
4. Click the + icon next to the Actions row.
5. Select the New SQL Action option from the dropdown menu.
6. Type the action’s name in the name field at the top of the editor and click the checkmark (✓) icon next to it.

The action is created based on the data source under which it is created. Actions created under Managed DB use Kuika’s managed database.

You can create a folder using the New Folder option in the same menu and organize your custom actions within that folder. The New Select Action option allows you to create a selection-based action without writing SQL.

Example Scenario: Department List Action

Purpose: To create an action in the application that lists the departments included in the employee list.

1. Create a table named Department.
2. Add the custom action named Select Department List.
3. In the SQL Editor, write the following query:

SELECT * FROM Department
WHERE DepartmentName LIKE @searchFor OR @searchFor IS NULL OR @searchFor = ''
ORDER BY DepartmentName;

1. View the parameters used by the query in the Parameters tab on the right panel and enter test values if necessary.
2. Click the Run button in the upper-right corner to test the query. You can view the results in the Result tab at the bottom of the editor, and any errors or warnings in the Messages tab.
3. Click the CREATE button to create the custom action.

The created action is listed under the Actions heading in the left panel. You can open, view, edit, or delete the action from here.

Custom actions used in any module cannot be deleted unless they are first removed from the module they are associated with. In this case, the system may display an error message.

Viewing Usage Locations

You can view on which pages and elements an SQL Action is used. This allows you to see, before making any changes, which parts of the application will be affected by changes made to the action.

Copying the Query with Parameters

In the action’s right-click menu, under the Edit SQL Action option, you’ll find the Copy query with parameters option. This option copies the query inside the action to the clipboard—with the parameter values entered on the screen already substituted—without requiring you to open the action. The copied query can be pasted directly into an SQL IDE and executed.

• Automatically inserted values: Parameters entered as “Fixed Value” and fixed default values (null, Empty, Space, True, False, Now, New Guid, Empty Guid). Values are formatted according to their type: string values are enclosed in single quotes, numeric values are written as plain numbers, and boolean values are written as 1/0 or true/false depending on the data source type.
• Non-auto-filled values: Parameters dependent on an element, Screen Input, Bag, or the result of another action are left exactly as they are in the format @parameterName / :parameterName. Since these values are determined only at runtime, they are unknown during the design phase; to avoid confusion, these fields must be filled in manually in the IDE.

The notification that appears after the copy operation shows how many parameters were automatically filled in (e.g., 3 of 8 parameter values filled in.). This allows you to immediately see how many fields need to be filled in manually.

You can create custom actions in Kuikada via UI Design or Datasources modules.

Steps:

1. Open the UI Design module.
2. Open the Custom Actions panel and select SQL Action.
3. Specify the action name and write your query in SQL Editor.

Creating SQL Queries

Kuika allows you to quickly add basic SQL queries:

• Add Select Query: List records in a table.
• Add Select By Id Query: Pull data based on a specific ID.
• Add Save Query: Insert or update data.
• Add Delete Query: Delete a specific record.
• Add Search By Keyword Query: Search data by keyword.
• Add Search With Pagination Query: Search data with pagination.

SQL Query Generation with Artificial Intelligence Assistant

1. Click on the Generate with AI button.
2. Select the table and enter the query description.
3. Add the generated query to the SQL Editor.

Example Command: “Create a query that lists only active departments.”

Testing and Saving SQL Queries

1. Run the query with the TEST button in the upper right corner.
2. Save the action by pressing the CREATE button.

SQL Editor Developer Tools

Kuika SQL Editor supports the following developer tools to streamline the query writing process and improve code quality:

• SQL Diagnostics: Syntax errors and potential issues in the written query are detected in real time; the user is alerted by highlighting the problematic areas.
• SQL Completion: While writing queries, auto-completion suggestions are provided for table names, column names, and SQL keywords; this reduces typos and speeds up the development process.
• SQL Formatter: It does not automatically format the query; when the TIDY UP button at the top of the SQL Editor is clicked, the query is formatted into a readable format by Kuika. Indentation, line spacing, and keyword consistency are adjusted during this process.

You can declare variables using the DECLARE statement in the Kuika SQL Editor.

General DECLARE Format

DECLARE @variable_name data_type;

Here:

• @variable_name: Variable name.
• data_type: SQL data type (e.g., nvarchar, int, bit).

Example Usages

1. Defining a Variable and Assigning Data

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

2. Calculating the Number of Rows

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

Using DECLARE with Kuika AI

1. Open the Kuika AI tab in the right panel.
2. Type a command to create a DECLARE statement that suits your needs.

Example command: “Create a DECLARE command that lists only active departments.”

The following system parameters can be used when creating an SQL Action in Kuika:

• @currentpage: Represents the page number.
• @pagesize: Specifies the number of records to return per page.
• @kuikausername: Represents the name of the user logged into Kuika.
• @kuikauserid: Represents the user’s identifier (GUID).

You can use these parameters to implement pagination, user-based data filtering, and dynamic SQL queries. Especially when working with large datasets, you can optimize your queries by dividing the data into pages using the @currentpage and @pagesize parameters.