Queries is a advanced functionality to create your own reports.
Page is used by creating a query either by using the Query Builder or if more advanced search functionality is needed by using the Expert Mode.
Query Builder
The query builder is used to build up a query using predefined commands.
Expert Mode
The expert mode is a text based version of the query builder to allow a query to be pasted in the input field.
Parameters
Parameter values can be added to the query. You also have to set the parameter type, for instance "Number" for at numeric value, "String List" for an array of string values.
Schema
Definitions of available entities and their values. This tab is for reference as the information is compiled by the system and the user cannot make any inputs.
Test Run
Here you can input values for your previously defined parameters and test the query by clicking the "Go" button.
An example
Carrier History:
The query says that we want to match a carrier id in the database that is equal to a supplied carrier id.
The same query can be written in text in the Expert Mode:
The supplied carrier id is set up by adding it as a parameter:
On the test run page we can try out our query to make sure it returns the intended result.
Input start date, end date and each parameter set up on the parameters tab. Then click "Go!". Results (if any) will be displayed in the field below.
