= Field value must be equal to the value supplied. addQuery('priority', '=', 3);
> Field must be greater than the value supplied. addQuery('priority', '>', 3);
< Field must be less than the value supplied. addQuery('priority', '<', 3);
>= Field must be equal to or greater than the value supplied. addQuery('priority', '>=', 3);
<= Field must be equal to or less than the value supplied. addQuery('priority', '<=', 3);
!= Field must not equal the value supplied. addQuery('priority', '!=', 3);
STARTSWITH Field must start with the value supplied. The example shown on the right will get all records where the short_description field starts with the text 'Error'. addQuery('short_description', 'STARTSWITH', 'Error');
ENDSWITH Field must end with the value supplied. The example shown on the right will get all records where the short_description field ends with text 'Error'. addQuery('short_description', 'ENDSWITH', 'Error');
CONTAINS Field must contain the value supplied anywhere in the field. The example shown on the right will get all records where the short_description field contains the text 'Error' anywhere in the field. addQuery('short_description', 'CONTAINS', 'Error');
DOES NOT CONTAIN Field must not contain the value supplied anywhere in the field. The example shown on the right will get all records where the short_description field does not contain the text 'Error' anywhere in the field. addQuery('short_description', 'DOES NOT CONTAIN', 'Error');
IN Field must contain the value supplied anywhere in the string provided. addQuery('sys_id', 'IN', '0331ddb40a0a3c0e40c83e9f7520f860,032ebb5a0a0a3c0e2e2204a495526dce');
INSTANCEOF Retrieves only records of a specified class for tables which are extended. For example, to search for configuration items (cmdb_ci table) you many want to retrieve all configuration items that are have are classified as computers. The code uses the INSTANCEOF operator to query for those records. addQuery('sys_class_name', 'INSTANCEOF', 'cmdb_ci_computer');