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.
Parts of an IQL
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. |
Constructing IQL queries
A basic IQL consists of a field followed by an operator followed by a value.
Examles:
Field Types
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. |
Operators
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 value 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. |
Conjunctions
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 |
Markdown Live Preview
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128 ## Iql Fields|Field|Type|Operators|Values|| ------------- | ------------- | ------------- | ------------- ||```adspace.category.id```|ADSPACE_CATEGORY|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```adspace.id```|ADSPACE|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```adspace.name```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```adspace.subcategory.id```|ADSPACE_SUB_CATEGORY|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```adspace.website```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```advertiser.alias```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```advertiser.attributes```|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||```advertiser.billingData.companyName```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```advertiser.billingData.email```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```advertiser.billingData.externalReferenceNumber```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```advertiser.billingData.vatId```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```advertiser.categoryId```|ADVERTISER_CATEGORY|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```advertiser.id```|ADVERTISER|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```advertiser.labels```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```advertiser.name```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```advertiser.phase```|ENUM|[EQUALS, NOT_EQUALS, IN]|Testing,Phase out,Phase out (only conversions)||```advertiser.promotionCountryCodes```|COUNTRY|[CONTAINS]|-||```advertiser.shortDescription```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```advertiser.startDate```|DATE_TIME|[EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL]|-||```advertiser.status```|ENUM|[EQUALS, NOT_EQUALS, IN]|Active,Deactivated,Deleted||```advertiser.trackingId```|STRING|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```advertiser.website```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```commissionModel.default```|ENUM|[EQUALS, IN]|True,False||```commissionModel.id```|STRING|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```commissionModel.name```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```commissionModel.status```|ENUM|[EQUALS, NOT_EQUALS, IN]|Active,Inactive,Deleted||```commissionRule.id```|STRING|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```commissionRule.name```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```commissionRule.status```|ENUM|[EQUALS, NOT_EQUALS, IN]|Active,Inactive,Deleted||```conversion.conversionId```|STRING|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```conversion.createdAt```|DATE_TIME|[EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL]|-||```conversion.documentId```|LONG|[EQUALS, NOT_EQUALS, LESS_THEN, LESS_OR_EQUAL, GREATER_THEN, GREATER_OR_EQUAL]|-||```conversion.status```|ENUM|[EQUALS, NOT_EQUALS, IN]|Open,Approved,Rejected,Confirmed||```conversion.touchpoint.subId1```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```conversion.touchpoint.subId2```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```conversion.touchpoint.subId3```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```conversion.touchpoint.subId4```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```conversion.touchpoint.subId5```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```conversion.touchpoint.subId6```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```conversion.uniqueId```|STRING|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```conversionExport.createdAt```|DATE_TIME|[EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL]|-||```conversionExport.requestExportUniqId```|STRING|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```conversionExport.status```|ENUM|[EQUALS, NOT_EQUALS, IN]|Pending,Processed,Failed||```conversionImport.createdAt```|DATE_TIME|[EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL]|-||```conversionImport.requestImportUniqId```|STRING|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```conversionImport.status```|ENUM|[EQUALS, NOT_EQUALS, IN]|Uploaded,Validated,Accepted,Cancelled,Processed||```conversionTarget.id```|STRING|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```conversionTarget.name```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```conversionTarget.status```|ENUM|[EQUALS, NOT_EQUALS, IN]|Active,Inactive||```creative.bannerId```|STRING|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```creative.code```|STRING|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```creative.createdAt```|DATE_TIME|[EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL]|-||```creative.description```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```creative.id```|STRING|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```creative.imageFormat```|ENUM|[EQUALS, NOT_EQUALS, IN]|Custom,Medium Rectangle (300x250),Square Pop Up (250x250),Wide Skyscraper (160x600),Vertical Rectangle (240x400),Large Rectangle (336x280),Rectangle (180x150),3:1 Rectangle (300x100),Pop-Under (720x300),Full Banner (468x60),Half Banner (234x60),Micro Bar (88x31),Button 1 (120x90),Button 2 (120x60),Vertical Banner (120x240),Square Button (125x125),Leaderboard (728x90),Skyscraper (120x600),Half Page Ad (300x600)||```creative.name```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```creative.status```|ENUM|[EQUALS, NOT_EQUALS, IN]|Active,Inactive,Hidden,Deleted||```creative.targetUrl```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```creative.type```|ENUM|[EQUALS, NOT_EQUALS, IN]|Image remote,Image hosted,HTML,Link||```creative.updatedAt```|DATE_TIME|[EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL]|-||```creativeSet.code```|STRING|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```creativeSet.createdAt```|DATE_TIME|[EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL]|-||```creativeSet.id```|STRING|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```creativeSet.name```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```creativeSet.status```|ENUM|[EQUALS, NOT_EQUALS, IN]|Active,Inactive,Hidden,Deleted||```creativeSet.updatedAt```|DATE_TIME|[EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL]|-||```entity.companyName```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```entity.id```|STRING|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```entity.lastChanged```|DATE_TIME|[EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL]|-||```entity.status```|ENUM|[EQUALS, NOT_EQUALS, IN]|Activated,Deleted||```feeModel.default```|ENUM|[EQUALS, IN]|True,False||```feeModel.id```|STRING|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```feeModel.name```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```feeModel.status```|ENUM|[EQUALS, NOT_EQUALS, IN]|Active,Inactive,Deleted||```feed.actionStatus```|ENUM|[EQUALS, NOT_EQUALS, IN]|Active,Deactivated,Deleted,Failed||```feed.id```|STRING|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```feed.status```|ENUM|[EQUALS, NOT_EQUALS, IN]|Active,Deactivated,Deleted,Failed||```job.createdAt```|DATE_TIME|[EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL]|-||```job.executionEndDateTime```|DATE_TIME|[EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL]|-||```job.executionLog```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```job.executionStartDateTime```|DATE_TIME|[EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL]|-||```job.executionStatus```|ENUM|[EQUALS, NOT_EQUALS, IN]|Planned,Succeeded,Failed||```job.executionTransferedBytes```|LONG|[EQUALS, NOT_EQUALS, LESS_THEN, LESS_OR_EQUAL, GREATER_THEN, GREATER_OR_EQUAL]|-||```job.executionTransferedTotal```|LONG|[EQUALS, NOT_EQUALS, LESS_THEN, LESS_OR_EQUAL, GREATER_THEN, GREATER_OR_EQUAL]|-||```job.id```|STRING|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```job.schedulePlannedDateTime```|DATE_TIME|[EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL]|-||```job.status```|ENUM|[EQUALS, NOT_EQUALS, IN]|Activated,Deactivated,Deleted||```job.type```|STRING|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```job.updatedAt```|DATE_TIME|[EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL]|-||```network.id```|STRING|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```partner.companyName```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```partner.firstName```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```partner.id```|PARTNER|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```partner.lastName```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```relationship.adspaceId```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```relationship.id```|STRING|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```relationship.lastChanged```|DATE_TIME|[EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL]|-||```relationship.status```|ENUM|[EQUALS, NOT_EQUALS, IN]|Applied,Active,Deactivated,Deleted,Not applied||```request.createdAt```|DATE_TIME|[EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL]|-||```request.status```|ENUM|[EQUALS, NOT_EQUALS, IN]|Inquired,Accepted,Rejected,Processed,Cancelled,Failed||```request.type```|ENUM|[EQUALS, NOT_EQUALS, IN]|Create new,Change existing||```request.uniqueId```|STRING|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```trackingCategory.id```|STRING|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```trackingCategory.name```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```trackingCategory.status```|ENUM|[EQUALS, NOT_EQUALS, IN]|Active,Deleted,Paused,Ended||```user.alias```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```user.email```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```user.firstName```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```user.id```|STRING|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```user.lastName```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```user.status```|ENUM|[EQUALS, NOT_EQUALS, IN]|Activated,Deactivated,Deleted||```user.type```|ENUM|[EQUALS, NOT_EQUALS, IN]|Partner,Agency,Platform||```webhook.log.code```|ENUM|[EQUALS, NOT_EQUALS, IN]|Unknown,Executed,Failed,Unsupported template parameter used,Skipped - Unsupported transition,Skipped - Status change without placeholder in Codeset,Skipped - Display mode Advertiser only||```webhook.log.id```|STRING|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```webhook.log.lastChanged```|DATE_TIME|[EQUALS, NOT_EQUALS, GREATER_OR_EQUAL, GREATER_THEN, LESS_THEN, LESS_OR_EQUAL]|-||```webhook.log.message```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```webhook.log.responseCode```|LONG|[EQUALS, NOT_EQUALS, LESS_THEN, LESS_OR_EQUAL, GREATER_THEN, GREATER_OR_EQUAL]|-||```webhook.log.status```|ENUM|[EQUALS, NOT_EQUALS, IN]|Succeeded,Failed,Scheduled||```webhook.replacements.id```|STRING|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```webhook.replacements.name```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```webhook.rule.id```|STRING|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```webhook.rule.name```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```webhook.targetConfiguration.id```|STRING|[IN, LIKE, ILIKE, EQUALS, NOT_EQUALS]|-||```webhook.targetConfiguration.name```|STRING|[LIKE, ILIKE, EQUALS, NOT_EQUALS]|-|
Iql Fields
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,Medium Rectangle (300x250),Square Pop Up (250x250),Wide Skyscraper (160x600),Vertical Rectangle (240x400),Large Rectangle (336x280),Rectangle (180x150),3:1 Rectangle (300x100),Pop-Under (720x300),Full Banner (468x60),Half Banner (234x60),Micro Bar (88x31),Button 1 (120x90),Button 2 (120x60),Vertical Banner (120x240),Square Button (125x125),Leaderboard (728x90),Skyscraper (120x600),Half Page Ad (300x600) |
| 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,Unsupported template parameter used,Skipped - Unsupported transition,Skipped - Status change without 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] | - |