String search
Word search

Define a query

Procedure

  1. Drag and drop the order items and operators in the query field.

    To create an SQL query, you can use:

    • The available order items

    • The available operators

    • The additional operators: ', ", +, -, /, %

    The following rules apply:

    • Numbers are integers. A decimal separator is not allowed.

    • String values are enclosed in quotation marks.

    • Dates are enclosed in quotation marks. A date must be a valid date according to the regional settings of the computer.

    • Enumeration values are enclosed in quotation marks.

    • Boolean values are enclosed in quotation marks.

    Examples:

    Type

    Valid value

    Invalid value

    Number

    53

    34.5

    String

    'Hello'

    Hello

    Dates

    '1/1/10'

    1/1/10

    Enumeration

    'Enum_value'

    Enum_value

    Boolean

    'True'

    True

  2. Example of a valid SQL query:

    [Date] >= '1/1/10'

Parent topic:
Create an export folder for orders
Privacy Terms of use Cookie information