JSON query syntax for getRecordListForTableWithQuery operations

The following examples show JSON query syntax to use in the getRecordListForTableWithQuery operation.

Keep the following in mind:

• Field names, string values, and keys are case insensitive.
• Fields can be specified using the field name or field code. Field name matching is case insensitive. Field codes must be enclosed in percent signs (e.g., %TRSET%).
• A field can only be used once in each query.
• Text strings must be enclosed in either single or double quotes (e.g., "string" or 'string'). Numbers do not require quotes.
• Booleans must be lowercase, but case insensitive strings are also supported. The following values are valid: true, false, 'True', 'False', "TRUE", "FALSE".
• If a query contains errors in multiple fields, errors are displayed alphabetically based on the field name.

Single field

Single value using field name

{'Test Run Set': 'WysiWrite 5.1'} //WysiWrite 5.1 value in the Test Run Set field

Single value using field code

{'%TRSET%': 'WysiWrite 5.1'} //WysiWrite 5.1 value in the Test Run Set field

Multiple values

{'%TRSET%': ['WysiWrite 5.1', 'WysiWrite 5.2']} //Test Run Set field value = WysiWrite 5.1 or WysiWrite 5.2

Can also use an explicit conjunction. Not valid for all field types.

{'Priority': ['High', 'Low']} //Priority = High OR Low)

Multiple fields

Field1 = Value1 AND Value2

Implicit AND

{'Test Run Set': 'WysiWrite 5.1',

Explicit AND

{'<and>':

}

Field1 = Value 1 OR Value 2 (explicit OR)

{'<or>':

}

Field1 = Value1 AND (Field2 = Value2 OR Field3 = Value3)

{'Test Run Set': 'WysiWrite 5.1',

}

Field1 = Value1 OR Field2 = value2 OR Field3=Value3

{

}

Field1 = Value1 AND Field2 = value2 AND Field3 = Value3

{

}

Field1 = Value1 AND (Field 2 = Value2 OR (Field3 = Value3 AND Field4 = Value4))

{'Test Run Set: 'WysiCorp 5.1',

'<or>': [

}

(Field1 != Value1) AND (Field2 = Value2 OR Field3 = Value3)

{'<not>': {'Status': 'On Hold'},

}

Field1 = Value1 AND NOT (Field2 = Value2 OR Field3 = Value3)

{'Automated Test: true,

}

Ranges

{"Test Case Number": {'<from>': 25, '<to>': 35}} //Test case numbers between 25 and 35

{"Test Case Number": {'<from>': 25}} //Test case numbers greater than 25

{"Test Case Number": { '<to>': 35}} //Test case numbers less than 35