Kullanıcı Kılavuzu

Select Action

Select Action

Kuika's Select Action feature automatically generates the SQL SELECT query for the table in a listing screen, allowing you to quickly perform data extraction without writing code. By selecting the data table and related table fields, you can define filtering criteria and sorting options. In this course, you will learn how to create a SQL SELECT query using Select Action.

This training content consists of the following topics:

  1. Anatomy of the Select Action modal
  2. Create a SQL SELECT query with Select Action
  3. Adjusting Select Action tab settings
  4. Complete SQL query without writing code with Select Action

Anatomy of Select Action Modal

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.

Create SQL SELECT Query with Select Action

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

Adjust Select Action Tab Settings

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.

Creating Select Action Query with Datasources Module

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

  1. Open the Datasources module.
  1. Click the + icon next to the Actions tab under the Sources panel and select New Select Action.
  2. 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!

Other Related Content

No items found.

Glossary

No items found.

Alt Başlıklar