CustomFieldValueQuery

Set of parameters used to filter custom field values.

More info: see custom field value, the getlist operation and the custom field values endpoint.

Fields

FieldDescription
typeid
int

Only return items with the given typeid.

Example value:10000
filter
string

Filter the returned items by specifying a query on the public datamodel that returns the ids.

Example value:"select id from tm.customfieldvalues WHERE createdts > (now() - INTERVAL '30 days')"
includearchived
bool

If this parameter is true, archived items will be returned as well.

Example value:true
lastupdatesince
timestamp

All items that were updated since this timestamp will be returned. Timestamp should be passed in YYYY-MM-DD hh:mm:ss format.

Example value:"2014-09-26 15:24:36"

Example

1{
2    "typeid": 10000,
3    "filter": "select id from tm.customfieldvalues WHERE createdts > (now() - INTERVAL '30 days')",
4    "includearchived": true,
5    "lastupdatesince": "2014-09-26 15:24:36"
6}