In the applications you develop with Kuika, one of the modules that you can add functionality to your application by creating SQL actions is the Datasources module. The datasources module is an important tool where you can manage the data structures and data sources of your application. With this module, you can quickly and efficiently define and integrate your SQL actions into your application while managing operations related to your data sources.
In the applications you develop with Kuika, one of the modules that you can add functionality to your application by creating SQL actions is the Datasources module. The datasources module is an important tool where you can manage the data structures and data sources of your application. With this module, you can quickly and efficiently define and integrate your SQL actions into your application while managing operations related to your data sources.
To create SQL actions in the Datasources module, the Actions heading in the left area is used. To create a new SQL action, you can click on the + icon opposite the Actions title. When you click on this icon, a detail menu opens and the action and folder options you can create are listed here. To create a new SQL action, simply click on SQL Action.
Clicking SQL Action opens an editor. At the top of the editor, there is a field that allows you to name the action. To the right of this field is the AI assistant. By enabling the AI assistant, you can get support to help you through the process of creating a SQL action. Details on the process of creating SQL actions with AI will be presented in subsequent learning content. To the right of the AI assistant is the Parameters heading. Through this heading, you can view the parameters in your query.
On the left side of the screen, there are Actions and Tables drop-down lists where you can list the custom actions in the application and the tables in the data source. The middle part 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, first expand the Tables list on the left side of the screen. When hovering over the relevant table, the dot-dot-dot menu to the right of the table name is displayed. By clicking on this menu, the desired query is selected and the selected query is applied in such a way that the SQL command is automatically added to the editor on the right side.
In addition to the default actions, if you want to create your own actions, you can create your own actions by writing the relevant SQL queries with the support of your technical knowledge and AI assistant.
Simply use the CREATE button to complete the SQL action creation process.
