tm.filterdefinition

A filter definition is used in selections to filter a list of items on certain conditions. It can be created for orders, contacts, events and tickets.

Fields

FieldDescription
id
int
Unique ID
typeid
int
Type ID
description<langcode>
mlstring
Name for the filter
sqlclause
string
The sql clause that defines how the filter will work
filtertype
int
The type of filter definition defines the UI and resulting parameters that will be used when a user selects the filter. The possible values can be found here.
checklistquery
string
For certain filter types, the user must select a value from a list. The checklistquery contains the sql clause to retrieve the list of available values.
createdts
timestamp
Created timestamp
lastupdatets
timestamp
Last updated timestamp
isarchived
bool
Whether or not this item is archived