In the application development process with Kuika, one of the modules you can use to create custom actions is the UI Design module. With this module, you can quickly and easily create SQL actions that will add functionality to your user interface designs.
In the application development process with Kuika, one of the modules you can use to create custom actions is the UI Design module. With this module, you can quickly and easily create SQL actions that will add functionality to your user interface designs.
To create SQL actions in the UI Design module, the Custom Actions panel on the left side of the module is used. Custom Actions panel allows the custom actions in the application to be listed in UI Design. To create a new SQL action, you can click the + icon on the panel. When you click this icon, the action and folder options you can create are listed. To create a new SQL action, simply click on SQL Action.
When you click on SQL Action, an editor modal screen presented by Kuika opens. On this screen, the tables in your data source are listed on the left side. At the top of the editor, there is a text input field that allows you to name the action. Next to this field is the AI assistant provided by Kuika. By enabling the AI assistant, you can provide support to assist you in your SQL action creation process. Detailed content about the process of creating SQL actions with AI will be presented in the next learning content.
The section in the center of the screen serves as an editor where you can enter commands that allow you to create SQL actions. For your convenience, Kuika offers Select, Select By ID, Save/Update, Delete, Search By Keyword and Search By Pagination queries by default. To add these queries, simply hover the cursor over the tables on the left side of the screen and click on the dot-dot-dot menu to the right of the table names. Through this menu, you can select the query you want to add and quickly add the relevant SQL command to the editor on the right.
If you want to create an action other than Select, Select By ID, Save/Update, Delete, Search By Keyword and Search By Pagination queries, you can write your own SQL query in the SQL editor on the screen.
Finally, you can view the parameters in the query via the Parameters tab on the right side of the screen.
To complete the SQL action creation process, simply use the CREATE button.
