Skip to main content

​
Schema

PropertyTypeDescription
idIDThe Chameleon ID
created_attimestampWhen this happened or when this was added to the Database
updated_attimestampThe last time any property was updated
kindstringThe type of Segmentation filter item: One of property, event, tour, action, intercom, or segment
integrationstringThe data partner if any
propstringThe specific property that forms the left hand side of an expression
opstringThe specific operation to be performed. Can be compounded with a value translation
valuestringThe specific Value that forms the right hand side of an expression
modstringA secondary condition is modified with this Operator
rangestringA secondary condition is compared with this Value
condstringA Secondary condition Operator used 1-to1 with int to form a time-range limitation on the main match
intstringUsed 1-to-1 with cond to specify an interval
Not all combinations of keys and values will work, see the other subsections for specific definitions and usage.

​
Operators

Note: The table below should be read with the description prefixed with The User property (is/has)…
Operatordescription
exHas any value (the key is present even null)
nxDoes not have any value (the key is missing)
eqEqual to
neNot equal to
gtGreater than (number, string or specific timestamp)
ltLess than
gt-dGreater than when the value is treated as a number of days in the past (timestamp is newer than X days ago)
lt-dLess than when the value is treated as a number of days in the past (timestamp is older than X days ago)
inContains (i.e. one string is contained within another)
in-iContains (case-insensitive)
ninNot contains
nin-iNot contains (case-insensitive)
in-vIncluded in the list when value is treated as a CSV
nin-vExcluded from list when the value is treated as a CSV
in-aThe property is an Array, is this value Included in the list
nin-aThe property is an Array, is this value Excluded from the list
Not all combinations of kinds and operators will work, see the other subsections for specific definitions and usage

​
Examples

Other examples can be found on the searching profiles page.

​
User whose “role is admin”

{
  "kind": "property",
  "prop": "role",
  "op": "eq",
  "value": "admin"
}

​
User whose “role is admin or owner or superuser”

Operator if in-v means treat the value as a CSV ["admin","owner","superuser"] and see if role is contained in the list. 
{
  "kind": "property",
  "prop": "role",
  "op": "in-v",
  "value": "admin,owner,superuser"
}

​
User was last seen more than 7 days ago

The postfix -d in lt-d instructs the value to be treated as a number of days. Subtract X days from the current time and look for last_seen_at values that are less than it. 
{
  "kind": "property",
  "prop":"last_seen_at",
  "op":"lt-d",
  "value":"7"
}

​
A filter that represents a Group of filters

{
  "kind": "group",
  "filters_op": "or",
  "filters": [
    {
      "kind": "property",
      "prop": "role",
      "op": "eq",
      "value": "admin"
    },
    {
      "kind": "property",
      "prop": "invited_users_count",
      "op": "gt",
      "value": "4"
    }
  ]
}

​
Other examples can be found on the searching profiles page.