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 field type description id int unique id typeid int type id description 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 https //www ticketmatic com/docs/api/settings/system/filterdefinitions/ 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