Comprehensive Query Features
Comprehensive Query features includes
Query Wizard
Custom SQL
Field Picker
Sort
Filter
Destination Setup
Query Wizard
Mention the required query name.
Select the connection.
Select Query Wizard.
Select the tables required.
In Query Wizard the tables will list all the entities in dropdown. Users can select the required entity and execute the query.
Custom SQL
Mention the required query name.
Select the connection.
Select Custom SQL.
In Custom SQL users need to mention the required entity in the SQL box. The format should be "select * from 'entity' "
Field Picker
In Query Wizard users can pick the required fields and display only those in Google Sheet.
Select the fields required by clicking on them.
Filter
Filter helps to Filter only the particular data needed.
Choose required Field.
Choose the operator required.
Mention the value to be filtered.
Click the "+" icon to add more filters.
Cell Value picker
Click on 'T' Icon
The menu will open
Select Cell value
You can provide your sheet name and range in format "Sheetname!Range"
Clicking on picker icon will pic the current selected cell.
Sort
Sorting helps to sort a value in ascending or descending order.
Choose the required field.
Select the value as ascending or descending.
Click the "+" icon to add more sorting.
Destination Setup
Choose the required sheet to save data.
Select the starting Cell.
Switch on Include Header to include header.
Switch on Clear Sheet before execution to clear old sheet data.
If new sheet needs to be created and data needs to be saved in that sheet:
Click the "+" icon in choose sheet.
Mention the required sheet name.
Click "✓" icon to save.
Click "✖ " icon to cancel.
