The advanced search allows you to build structured queries using the Ingenious Query Language (IQL) to search your data using APIs that support IQL.
IQL is not a database query language, even though it uses SQL-like syntax. |
Part | Examples | Description |
---|---|---|
Field (mandatory) | advertiser.name | Field in the queried data on which this IQL (or part of it) operates |
Operator | = != IN | Comparison method of the fields value with the value presented in the IQL |
Value | ‘My Advertiser’ | A constant value to compare the preceding field-data with using the given operator. |
Conjunction (optional) | AND, OR | Allows the building of complex IQL by conjoining multiple IQL. |
A basic IQL consists of a field followed by an operator followed by a value. |
Examles:
advertiser.id = '2321' |
advertiser.id IN ('2321', '3221') OR advertiser.name = 'My Advertiser' |
advertiser.id IN ('2321', '3221') OR (advertiser.status = 'ACTIVE' AND advertiser.phase = 'TESTING') |
Each field has a data type defining what values it can be compared against as well as the operators that are allowed. |
Note that certain fields may further limit the number of available operators. |
Type | Possible operators | Examples | Description |
---|---|---|---|
LONG DOUBLE | EQUALS, NOT_EQUALS, LESS_THEN, LESS_OR_EQUAL, GREATER_THEN, GREATER_OR_EQUAL |
| Numeric values |
DATE DATE_TIME | EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL |
| Date / DateTime values in ISO 8601 |
STRING | IN, LIKE, ILIKE, EQUALS, NOT_EQUALS |
| Text |
ENUM | EQUALS, NOT_EQUALS, IN |
| String values from a list of available options. |
Custom Types (ADVERTISER, PARTNER, …) | IN, LIKE, ILIKE, EQUALS, NOT_EQUALS |
| Represents an object in Ingenious by its Identifier. Otherwise, behaves exactly like STRING. |
Operator | Syntax | Syntax example | Description |
---|---|---|---|
LIKE ILIKE | LIKE ILIKE |
| Compares field data and value. The |
EQUALS NOT_EQUALS | = != |
| Field data and value for equality / inequality. |
IN | IN |
| Checks whether the field's data is equal to any of the given values. |
LESS_THEN GREATER_THEN GREATER_OR_EQUAL LESS_OR_EQUAL | < > >= <= |
| Checks whether field data is greater, greater equal, less, less or equal than the value given. |
CONTAINS | CONTAINS |
| Checks that all given values are contained in the field data |
Conjunction | Example | Description |
---|---|---|
AND |
| Result must match both the left-hand and the right-hand part of the IQL |
OR |
| Result must match either the left-hand or the right-hand part of the IQL |
Content below is generated using IqlConfigTest in common.iql. DO NOT EDIT |
Field | Type | Operators | Values |
---|---|---|---|
| ADSPACE_CATEGORY | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| ADSPACE | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| ADSPACE_SUB_CATEGORY | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| ENUM | [CONTAINS] | FIRST_PARTY_TRACKING,BASKET_FREEZE,NATIVE_MOBILE_TRACKING,METADATA_TRACKING,CLICK_ID_TRACKING,BOUNCELESS_TRACKING,MULTI_TOUCH_ATTRIBUTION,PRODUCT_DATA_FEED,VOUCHER,DEEPLINK,CREATIVE_TEXT,CREATIVE_IMAGE,CREATIVE_IMAGE_HOSTED,CREATIVE_HTML,POST_VIEW_COMMISSION,POST_CLICK_COMMISSION |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| ADVERTISER_CATEGORY | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| ADVERTISER | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| ENUM | [EQUALS, NOT_EQUALS, IN] | TESTING,PHASE_OUT,PHASE_OUT_ONLY_CONVERSIONS |
| COUNTRY | [CONTAINS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| DATE_TIME | [EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL] | - |
| ENUM | [EQUALS, NOT_EQUALS, IN] | ACTIVE,DEACTIVATED,DELETED |
| STRING | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| ENUM | [EQUALS, IN] | TRUE,FALSE |
| STRING | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| ENUM | [EQUALS, NOT_EQUALS, IN] | ACTIVE,INACTIVE,DELETED |
| STRING | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| ENUM | [EQUALS, NOT_EQUALS, IN] | ACTIVE,INACTIVE,DELETED |
| STRING | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| DATE_TIME | [EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL] | - |
| LONG | [EQUALS, NOT_EQUALS, LESS_THEN, LESS_OR_EQUAL, GREATER_THEN, GREATER_OR_EQUAL] | - |
| ENUM | [EQUALS, NOT_EQUALS, IN] | OPEN,APPROVED,REJECTED,CONFIRMED |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| DATE_TIME | [EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL] | - |
| STRING | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| ENUM | [EQUALS, NOT_EQUALS, IN] | PENDING,PROCESSED,FAILED |
| DATE_TIME | [EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL] | - |
| STRING | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| ENUM | [EQUALS, NOT_EQUALS, IN] | UPLOADED,VALIDATED,ACCEPTED,CANCELLED,PROCESSED |
| STRING | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| ENUM | [EQUALS, NOT_EQUALS, IN] | ACTIVE,INACTIVE |
| STRING | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| DATE_TIME | [EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| ENUM | [EQUALS, NOT_EQUALS, IN] | Custom,MediumRectangle,SquarePopUp,WideSkyscraper,VerticalRectangle,LargeRectangle,Rectangle,Rectangle3To1,PopUnder,FullBanner,HalfBanner,MicroBar,Button1,Button2,VerticalBanner,SquareButton,Leaderboard,Skyscraper,HalfPageAd |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| ENUM | [EQUALS, NOT_EQUALS, IN] | ACTIVE,INACTIVE,HIDDEN,DELETED |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| ENUM | [EQUALS, NOT_EQUALS, IN] | IMAGE_REMOTE,IMAGE_HOSTED,HTML,LINK |
| DATE_TIME | [EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL] | - |
| STRING | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| DATE_TIME | [EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL] | - |
| STRING | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| ENUM | [EQUALS, NOT_EQUALS, IN] | ACTIVE,INACTIVE,HIDDEN,DELETED |
| DATE_TIME | [EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| DATE_TIME | [EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL] | - |
| ENUM | [EQUALS, NOT_EQUALS, IN] | ACTIVATED,DELETED |
| ENUM | [EQUALS, IN] | TRUE,FALSE |
| STRING | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| ENUM | [EQUALS, NOT_EQUALS, IN] | ACTIVE,INACTIVE,DELETED |
| ENUM | [EQUALS, NOT_EQUALS, IN] | ACTIVE,DEACTIVATED,DELETED,FAILED |
| STRING | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| ENUM | [EQUALS, NOT_EQUALS, IN] | ACTIVE,DEACTIVATED,DELETED,FAILED |
| DATE_TIME | [EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL] | - |
| DATE_TIME | [EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| DATE_TIME | [EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL] | - |
| ENUM | [EQUALS, NOT_EQUALS, IN] | PLANNED,SUCCEEDED,FAILED |
| LONG | [EQUALS, NOT_EQUALS, LESS_THEN, LESS_OR_EQUAL, GREATER_THEN, GREATER_OR_EQUAL] | - |
| LONG | [EQUALS, NOT_EQUALS, LESS_THEN, LESS_OR_EQUAL, GREATER_THEN, GREATER_OR_EQUAL] | - |
| STRING | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| DATE_TIME | [EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL] | - |
| ENUM | [EQUALS, NOT_EQUALS, IN] | ACTIVATED,DEACTIVATED,DELETED |
| STRING | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| DATE_TIME | [EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL] | - |
| STRING | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| PARTNER | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| DATE_TIME | [EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL] | - |
| ENUM | [EQUALS, NOT_EQUALS, IN] | APPLIED,ACTIVE,DEACTIVATED,DELETED,NOT_APPLIED |
| DATE_TIME | [EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL] | - |
| ENUM | [EQUALS, NOT_EQUALS, IN] | INQUIRED,ACCEPTED,REJECTED,PROCESSED,CANCELLED,FAILED |
| ENUM | [EQUALS, NOT_EQUALS, IN] | CREATE_NEW,CHANGE_EXISTING |
| STRING | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| ENUM | [EQUALS, NOT_EQUALS, IN] | ACTIVE,DELETED,PAUSED,ENDED |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| ENUM | [EQUALS, NOT_EQUALS, IN] | ACTIVATED,DEACTIVATED,DELETED |
| ENUM | [EQUALS, NOT_EQUALS, IN] | PARTNER,AGENCY,PLATFORM |
| ENUM | [EQUALS, NOT_EQUALS, IN] | UNKNOWN,EXECUTED,FAILED,UNKNOWN_TEMPLATE_PARAMETER_USED,SKIPPED_UNSUPPORTED_TRANSITION,SKIPPED_STATUS_CHANGE_WITHOUT_STATUS_PLACEHOLDER_IN_CODESET,SKIPPED_DISPLAY_MODE_ADVERTISER_ONLY |
| STRING | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| DATE_TIME | [EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| LONG | [EQUALS, NOT_EQUALS, LESS_THEN, LESS_OR_EQUAL, GREATER_THEN, GREATER_OR_EQUAL] | - |
| ENUM | [EQUALS, NOT_EQUALS, IN] | SUCCEEDED,FAILED,SCHEDULED |
| STRING | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [IN, LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |
| STRING | [LIKE, ILIKE, EQUALS, NOT_EQUALS] | - |