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.