Create Custom Actions with SQL Editor in Datasources Module

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.

Description:

1. Log in to the Kuika platform and open your project from the Apps screen.
2. Open the Datasources module from the left menu.

3. Click the + icon next to the Actions tab.
4. Select New SQL Action from the drop-down menu.

To organize custom actions, you can create a folder and store the actions in this folder.

Example Scenario: Department List Action

Objective: To create an action that lists the departments in the personnel list in the application.

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

SELECT * FROM DepartmentWHERE DepartmentName LIKE @searchFor OR @searchFor IS NULL OR @searchFor =ORDER BY DepartmentName;

4. Test the query by clicking the TEST button.
5. Create the custom action by clicking the CREATE button.

6. You can view, edit or delete the action created in the left panel with the Edit button.

Custom actions used in the related module cannot be deleted without removing them from the module they are related to. In this case, the system may display an error message.