SQL ENTRY AND PREPARING SQL QUERIES

Creating Custom Actions with SQL editor in Kuika

While developing applications with Kuika, you can use Custom Actions that you will create through SQL queries to improve the functions of your application and enrich the functions in your application.

For example, In an e-commerce application that we assume you are developing in Kuika, you can use a custom action that you will create using a SQL query to add products.

While developing applications with Kuika, you can use Custom Actions that you will create through SQL queries to improve the functions of your application and enrich the functions in your application.

For example, In an e-commerce application that we assume you are developing in Kuika, you can use a custom action that you will create using a SQL query to add products.

In Kuika, you can use UI Design view mode or Datasources view mode to create adding custom actions.

Let's take a look at how to create a custom action in UI Design view mode.

Creating a Custom Action in UI Design Module


To add a new custom action, open the Custom Actions panel in UI Design view mode. Then click the Add SQL Action button in the Custom Actions panel. On the incoming screen, the data source tables you added to your application and the SQL Editor will greet you. Kuika offers Select, Select By Id, Save/Update, Delete, Search By Keyword and Search By Pagination queries by default for your convenience. To create a new action by adding these queries, hover over the tables on the left side of the screen with the cursor. By clicking on one of the Select, Select By Id, Save/Update, Delete, Search By Keyword and Search By Pagination queries you want to add via the dot-dot-dot menu to the right of the table names, you can see that the relevant query is added to the SQL editor on the right. You can view the parameters in the query via the Parameters tab at the top. 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 the SQL query that creates the action you want to create in the SQL editor on the screen. You can also create SQL queries in seconds using the artificial intelligence assistant offered by Kuika to increase your productivity. The important thing here is to write the correct prompt clearly.

To complete the action creation process, name the action you created and click the CREATE button.After the steps to create a custom action in UI Design view mode, let's examine the steps to create a custom action in Datasources view mode, another view mode used to create custom actions.

Creating a Custom Action in Datasources Module

To create a new custom action in Datasources view mode, first open Datasources view mode. On the screen that opens, when you hover over the Actions sub-panel on the left, a + icon appears next to the Actions title. Click on the + icon to open the new action creation screen. On the next screen, you will be greeted by a SQL editor created by Kuika. On the SQL Editor screen, you can write the relevant SQL query for the custom action you want to create. During the SQL query writing process, you can obtain the SQL query in seconds by typing the correct prompt using the artificial intelligence assistant provided by Kuika.

Kuika offers Select, Select, Select By Id, Save/Update, Save/Update, Delete, Search By Keyword and Search By Pagination queries by default in this screen, just like in the Custom Actions panel. To create a new action by adding these queries, expand the Tables sub-panel on the left side of the screen. Then hover over the data table where you want to create the query and open the detail menu.

Add the relevant query text using the Detail menu.To complete the query addition process, click the CREATE button in the upper right corner.That's it!You are now ready to create your own custom action.In the next learning content, we will create custom actions for the screens we have prepared by applying the above-mentioned operations, using the data table we have prepared. Thus, you will be able to create a custom action in Kuika in the context of a sample scenario.

While developing applications with Kuika, you can use Custom Actions that you will create through SQL queries to improve the functions of your application and enrich the functions in your application.

For example, In an e-commerce application that we assume you are developing in Kuika, you can use a custom action that you will create using a SQL query to add products.

While developing applications with Kuika, you can use Custom Actions that you will create through SQL queries to improve the functions of your application and enrich the functions in your application.

For example, In an e-commerce application that we assume you are developing in Kuika, you can use a custom action that you will create using a SQL query to add products.

In Kuika, you can use UI Design view mode or Datasources view mode to create adding custom actions.

Let's take a look at how to create a custom action in UI Design view mode.

Creating a Custom Action in UI Design Module


To add a new custom action, open the Custom Actions panel in UI Design view mode. Then click the Add SQL Action button in the Custom Actions panel. On the incoming screen, the data source tables you added to your application and the SQL Editor will greet you. Kuika offers Select, Select By Id, Save/Update, Delete, Search By Keyword and Search By Pagination queries by default for your convenience. To create a new action by adding these queries, hover over the tables on the left side of the screen with the cursor. By clicking on one of the Select, Select By Id, Save/Update, Delete, Search By Keyword and Search By Pagination queries you want to add via the dot-dot-dot menu to the right of the table names, you can see that the relevant query is added to the SQL editor on the right. You can view the parameters in the query via the Parameters tab at the top. 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 the SQL query that creates the action you want to create in the SQL editor on the screen. You can also create SQL queries in seconds using the artificial intelligence assistant offered by Kuika to increase your productivity. The important thing here is to write the correct prompt clearly.

To complete the action creation process, name the action you created and click the CREATE button.After the steps to create a custom action in UI Design view mode, let's examine the steps to create a custom action in Datasources view mode, another view mode used to create custom actions.

Creating a Custom Action in Datasources Module

To create a new custom action in Datasources view mode, first open Datasources view mode. On the screen that opens, when you hover over the Actions sub-panel on the left, a + icon appears next to the Actions title. Click on the + icon to open the new action creation screen. On the next screen, you will be greeted by a SQL editor created by Kuika. On the SQL Editor screen, you can write the relevant SQL query for the custom action you want to create. During the SQL query writing process, you can obtain the SQL query in seconds by typing the correct prompt using the artificial intelligence assistant provided by Kuika.

Kuika offers Select, Select, Select By Id, Save/Update, Save/Update, Delete, Search By Keyword and Search By Pagination queries by default in this screen, just like in the Custom Actions panel. To create a new action by adding these queries, expand the Tables sub-panel on the left side of the screen. Then hover over the data table where you want to create the query and open the detail menu.

Add the relevant query text using the Detail menu.To complete the query addition process, click the CREATE button in the upper right corner.That's it!You are now ready to create your own custom action.In the next learning content, we will create custom actions for the screens we have prepared by applying the above-mentioned operations, using the data table we have prepared. Thus, you will be able to create a custom action in Kuika in the context of a sample scenario.

Yardımcı kaynaklar

Glossary