Creating a Select Action

During the application development process with Kuika, you can use the Select Action offered by Kuika to pull complex records from a data table in a data source.

Through Select Action, you can quickly create Complex Select queries by making a few simple selection operations without writing any code.

Within the scope of this learning content, let's create an action called SelectIdea to pull data to the Dashboard screen in the web application we prepared in the Designer 1 course.

Open the I Have an Idea web application.

1. Open the Custom Actions panel in the panels on the left side.
2. Click on the + icon next to Managed DB.
3. Select Select Action from the menu.
4. On the screen that opens, give your action a name.

Let's continue with source selection.

5. Click on the + icon in the Choose Source field and select the Idea table from the drop-down menu.
6. Click on the link icon next to the Idea table. This will allow you to create complex actions using the tables related to the Idea table.
7. From the screen that opens, select the Personnel table that is related to the Idea table.
8. Let's do the same for the IdeaCategory table this time.

Now let's make Field selections

9. Open the Fields tab.
10. Through this tab, you are expected to select the columns to be used in the related action among the columns in each of the three tables. For example, we want to list images of ideas on the Dashboard screen. In this tab, we need to first select the Idea table and then select the image column in the table. After the selection process, if we want, we can give these columns an Alias, that is, an identifying name.
11. Let's proceed by adding to the default selections on the Fields tab.
12. After selecting the relevant columns, you can give these columns an Alias, that is, a descriptive name.
13. Columns to be selected in the Idea Table 

• Id (Alias: IdeaID)
• CreatedDate,
• IdeaHolder,
• IdeaImage,
• Make Ideatitle selections.

Now let's proceed by adding the columns in the Personnel table.

• ID (Alias: PersonnelID)
• Fullname
• PersonnelImage,
• Make Title selections.
• Add the ID in the Category table and name it as CategoryID via Alias.
  Make sure CategoryName is selected in the Category table.

Let's create a sorting structure on the Dashboard screen so that the ideas are listed from the last added to the first added.

14. Now open the SortOrder tab,
15. Select the Idea table, select CreatedDate as column, and select Descending

Action Testing and Saving

16. You can test the action through the Preview tab.
    However, since we have not yet added records to the data tables, the test result will be empty.
17. After your operations, save the action by clicking the Create button.

We expect you to create similar actions for the idea listing screen in the web application, Dashboard, and idea listing screens in the mobile application using the Select action.