/mcpKeys and NULL Option Data Type Description Name NOT NULL DBINT Indicates what kind of comparison is done on the attribute. Default is 1. Values are: • 0 = Unknown • 1 = equal • 2 = not equal • 3 = less than • 4 = less than or equal • 5 = greater than • 6 = greater than or equal • 7 = between (inclusive) • 8 = member • 9 = agent has attribute, regardless of value • 10 = agent does not have attribute • 11 = not member AttributeRelation NULL VARCHAR(255) The value that the attribute is tested against. If AttributeRelation is member or not member, then this is a JSON compatible string listing the values. Must be convertible to the datatype specified in the Attribute table. Value1 NULL VARCHAR(255) A second value, used only as the upper bound when the AttributeRelation is between. It also can contain additional values for member if Value1 is not enough. Must be convertible to the datatype specified in the Attribute table. Value2 Query_Rule This table is in the Blended Agent category (see Blended Agent (Outbound Option), on page 616). To see database rules for these tables, see Blended Agent Tables (Outbound Option), on page 695. Specifies the association between a query rule clause and an import rule. A query rule works on a particular import rule to select a group of contacts from an overall import list. For example, from a particular import list you might want to select and call all customers that have account numbers greater than 10,000. Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 362 All Tables Query_Rule