Working in Datasources View Mode for Data Transfer to Select Box Element

In order to transfer data to the Select Box element in the application development process with Kuika, you must first perform some operations in the Datasources module. You can transfer your data to Select Box by following the steps below.

1. Open the “Datasources” module.
2. Create a data table that will contain the data you want to transfer to Select Box. You can create a “Department” table within the scope of the example scenario.

2.1. Adding a New Table

1. In the Datasources Module, hover over the “Tables” heading on the left.
2. Click on the "+ ” icon next to Tables.
3. Click on “New Table” through the menu that opens.

4. On the screen that appears, type Department as the table name and click on the “NEXT” button.

2.2. Adding Columns

In the screen that appears, you will see a column named Id of Guid type created by Kuika by default.

1. Enter Column Name to add a new column.
2. Then, select the data type from the drop-down menu under Column Type. In the example scenario, add DepartmentName (String type) as a column to be included in the Department table.
3. You must use English characters when adding the column name; avoid using special characters.

2.3 Completing Columns

1. After filling in the Column Name and Column Type information, select the necessity and uniqueness status and click the “Add” button.
2. You can list the columns you added in the Department table and delete them when necessary.
3. After completing the column addition process, create the table by clicking the “CREATE” button in the upper right corner.

3. Creating a Custom Action

After the table creation process, you should create a custom action that will list the data in the Select Box element.

3.1 Adding New SQL Action

1. In the Datasources module, hover over the Actions heading on the left.
2. Click on the “+” icon next to the “Actions” title.
3. Click on “New SQL Actions” from the drop-down menu.

3.2 Naming The Actions

On the screen that opens, name your action and click “Next”. For the example scenario, you can use the name SelectDepartment for the action that will list the departments in the Select Box.

3.3 Using SQL Action

A SQL Editor will greet you on the screen that opens. In the SQL Editor, write the SQL query required for the listing. You can use the following query to create the SelectDepartment action to be used in the example scenario:

SELECT * FROM Department

In Kuika, you can quickly and easily create a Select query without writing any query expression. To create the listing action quickly and easily, click Tables on the left menu of the SQL editor screen. Hover over theDepartment table with the cursor and open the detail menu.

1. Click on “Add Select Query” in the menu that opens.
2. After clicking “Add Select Query”, the Select query will be automatically added to the SQL editor.

By following these steps, you can successfully transfer data to the Select Box element.