To form queries
You can form queries for attributes.
About this task
To form queries:
Procedure
- Edit the custom input XML of any list API, and append QryType to any attribute you want to query on. Any attribute that is not appended with QryType can also be queried on, using the default query type value EQ, as shown for ShipNode in the example in the topic on forming queries in the input XML of list APIs.
- For attributes appended with QryType, specify a query type value from the following table. This is case sensitive.
- Specify the values that are applicable to your search criteria.
The values for the QryType attributes vary depending on the datatype of the field. The following table lists the supported query type values for each datatype.
Field DataType Supported Query Type Values Char/VarChar2 - EQ - Equal to
- FLIKE - Starts with
- LIKE - Contains
- GT - Greater than
- LT - Less than
- NE - Not equal to
Number - BETWEEN - Range of values
- EQ - Equal to
- GE - Greater than or equal to
- GT - Greater than
- LE - Less than or equal to
- LT - Less than
- NE - Not equal to
Date - DATERANGE - Range of dates
- EQ - Equals
- GE - Greater than or equal to
- GT - Greater than
- LE - Less than or equal to
- LT - Less than
- NE - Not equal to
Date-Time - BETWEEN - Range of dates
- EQ - Equals
- GE - Greater than or equal to
- GT - Greater than
- LE - Less than or equal to
- LT - Less than
- NE - Not equal to
Note: For nullable columns where the column or attribute is set to Nullable in the entity XML, you can use the following query types:- ISNULL - Return records that are null.
- NOTNULL - Return records that are not null.