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

    '01/01/2010'

    01/01/2010

    Enumeration

    'Enum_value'

    Enum_value

    Boolean

    'True'

    True

  2. Example of a valid SQL query:

    [Date] >= '01/01/2010'

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