Columns

The FILTER table contains the following columns. Columns marked with an asterisk comprise the primary key.

Column Name Data Type
ID* String(255)
ACCOUNTID String(255)
ADVANCEDDETAILS​_CASESENSITIVE Boolean
ADVANCEDDETAILS​_EXTRACTA String(255)
ADVANCEDDETAILS​_EXTRACTB String(255)
ADVANCEDDETAILS​_FIELDA String(255)
ADVANCEDDETAILS​_FIELDAREQUIRED Boolean
ADVANCEDDETAILS​_FIELDB String(255)
ADVANCEDDETAILS​_FIELDBREQUIRED Boolean
ADVANCEDDETAILS​_OUTPUTCONSTRUCTOR String(255)
ADVANCEDDETAILS​_OUTPUTTOFIELD String(255)
ADVANCEDDETAILS​_OVERRIDEOUTPUTFIELD Boolean
CREATED Datetime(3)
EXCLUDEDETAILS​_CASESENSITIVE Boolean
EXCLUDEDETAILS​_EXPRESSIONVALUE String(255)
EXCLUDEDETAILS​_FIELD String(255)
EXCLUDEDETAILS​_MATCHTYPE String(255)
INCLUDEDETAILS​_CASESENSITIVE Boolean
INCLUDEDETAILS​_EXPRESSIONVALUE String(255)
INCLUDEDETAILS​_FIELD String(255)
INCLUDEDETAILS​_MATCHTYPE String(255)
LOWERCASEDETAILS​_FIELD String(255)
NAME String(255)
PARENTLINK​_HREF URL(255)
PARENTLINK​_TYPE String(255)
SEARCHANDREPLACEDETA​ILS​_CASESENSITIVE Boolean
SEARCHANDREPLACEDETA​ILS​_FIELD String(255)
SEARCHANDREPLACEDETA​ILS​_REPLACESTRING String(255)
SEARCHANDREPLACEDETA​ILS​_SEARCHSTRING String(255)
SELFLINK URL(255)
TYPE String(255)
UPDATED Datetime(3)
UPPERCASEDETAILS​_FIELD String(255)