In order to transfer data to the Select Box element in the application development process with Kuika, you must first perform some operations in Datasources view mode.
First, open Datasources view mode.
Then create the data table that will contain the data you want to transfer to the Select Box. You can create a Department table within the scope of the example scenario.
To add the Department table, hover over the Tables heading on the left. Click on the + icon next to Tables.
Click New Table via the drop-down menu. On the screen that appears, type Department as the table name and click the NEXT button.
In the screen you see, a column named Id in Guid type is created by Kuika by default.
Enter Column Name to add a new column. Then select the data type via the drop-down menu under the Column Type heading.
In the example scenario, add the columns and column types to be included in the Department table. In this context, add a DepartmentName column with column type String.
You should use English characters when adding a column name. You should also not use special characters.
Fill in the Column Name and Column Type information to perform the insertion process. Select the requirement and uniqueness status for the column and click the Add button.
You can list the columns you added in the Department table and delete them when necessary.
After completing the column addition process, create the table by clicking the CREATE button in the upper right corner.
After the table creation process, you must create the custom action that will list the data in the Select Box element.
To add a new custom action, hover over the Actions title on the left in Datasources view mode. Click on the + icon next to the Actions title.
Click New Custom Action from the drop-down menu.
In the Add a New Action screen, name the action and click Next.
Within the scope of the example scenario, you can use the name SelectDepartment for the action that will list the departments in the Select Box.
A SQL Editor will greet you on the screen that opens. Write the SQL query required for listing in the SQL Editor.
You can use the following query to create the SelectDepartment action to be used in the example scenario.
CopySELECT * FROM DepartmentIn Kuika, you can create the Select query quickly and easily 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 the Department table with the cursor. Open the detail menu.
Click Add Select Query in the menu that opens.
After clicking Add Select Query, the Select query will be automatically added to the SQL editor.