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]|-|