The Select Action panel has the following functions:

On the left edge of the panel:

• Action Name (1): Used to name the query.
• Choose Source (2): Allows you to select the data source.

At the top right of the panel:

• Relations (3): You can create queries by adding and associating data tables.
• Fields (4): Allows you to select fields from data tables.
• Filter (5): Helps you filter the data.
• Sort Order (6): Allows you to determine the sort order of the data.
• Preview (7): You can preview the query and view the results.
• Convert to SQL Action (8): Allows you to convert the query you created into a SQL query.

In the bottom right corner:

• CREATE (9): Used to save the query.

1. Log in to the Kuika platform and open the project you will work on from the Apps screen.

2. In the UI Design module, open the Custom Actions panel on the left side.
3. Click on the + icon next to the Managed DB title and select the Select Action option.
4. Name the query in the window that opens.
5. Click the + icon to select the data source. You can select a table you created before as a data source.
6. Configure Fields, Filter and Sort Order settings according to your needs.

Relations

• From the Relations tab, you can select the tables you created before as data source and associate them with different tables.

Fields

• In the Fields tab, select the information you want to list.
• You can group data using functions such as Group By, Count, Min, Max.
• You can give more meaningful names to columns using Alias.

Filter

• It is used to filter data that meets certain criteria.
• You can create logical connections with AND and OR operators.
  
  • AND: All conditions must be met.
  • OR: It is sufficient to satisfy any of the conditions.

Example:

• To select employees in the “Team Leader” role working in the “Design” department:
  
  • DepartmentName = 'Design' AND Title = 'Team Leader'
• To select employees in the “Design” or “Marketing” department:
  
  • DepartmentName = 'Design' OR DepartmentName = 'Marketing'

Sort Order

• Used to sort data in ascending or descending order.

Preview

• You can preview the query you have created.

If there is no data stored in the related data table, the Preview field will be empty.

Convert to SQL Action

• It is used to convert the action you created to SQL query.

After clicking Convert to SQL Action, you cannot go back to Select Action mode. Editing operations can be done through SQL Editor.

You can also create a Select query through the Datasources module:

1. Open the Datasources module.

2. Click the + icon next to the Actions tab under the Sources panel and select New Select Action.
3. By following the steps in the UI Design module, you can also use the Select Action feature in the Data Sources module.

With Kuika, it's that easy to create SQL queries without writing code!