Common Query Examples

Queries are what bring in the fields wanted for a report in a data set.

Here is a list of common query syntax that can be used:

  • Adding a field:
  • Select <field_name> From <table_name>
  • Adding a table:
  • Select * From <table_name>
  • Specify a field alias:
  • Select <field_name> AS <alias_name> From <table_name>
  • Join tables:
  • Inner Join: Select table1_name.column_name From table1_name Inner Join table2_name On table1_name.column_name = table2_name.column_name
  • Left Outer Join: Select table1_name.column_name From table1_name Left Join Table2_name On table1_name.column_name = table2_name.column_name
  • Right Outer Join: Select table1_name.column_name From table1_name Right Join table2_name ON table1_name.column_name = table2_name.column_name
  • Sort data:
  • Select * From <table_name> Order By <field_name> ASC/DSC
  • Filter data:
  • Select * From <table_name> where [CONDITION]
  • Apply Aggregate Functions:
  • Select aggregate_function(table_name.field_name) From <table_name> Where [CONDITION].
  • Grouping:
  • Select * From <table_name> Where [CONDITION] Group By <table_name.field_name>.

You can add to your query to sort data in either ascending or descending order based on one or more fields in the table.

  1. Edit the data set and add Order By <field_name> ASC/DSC.
  2. For example, the image below has added Order by initiatedate ASC to the query to sort the report in ascending order by the initiated date.