Query format

Report queries in Administration Web Interface must be defined in a certain structure. They consist of the following:

• A data field, which is a field from the database.
• An operator, which is the operation to be performed on the data field.
• A value, which is the value the data field will be compared against. Some operators do not need a value.

Sample structures are as follows:

• DATAFIELDOPERATOR. For example, CLIENTTYPE ISBLANK
• DATAFIELDOPERATORVALUE. For example, CLIENTTYPE INCLUDES 'W'
• DATAFIELDOPERATORVALUEVALUE. For example, CLIENTTYPE INCLUDES 'W' 'A'

Two or more values after the operator will be interpreted as if the word 'and' was between them (logical AND).

For more information about the query operators, see Query operators.