System Fields

This guide explains how to use System Fields in filters for Workflows and the External API. System fields are automatically added to every entry and can be used in filters, searches, and columns.

What Are System Fields?

Every entry now includes the following system fields:

Field Name	Field ID	Type	Description
`autoId`	1	text	Unique ID of the entry
`createdAt`	2	datetime	When the entry was created
`updatedAt`	3	datetime	When the entry was last updated
`createdBy`	4	number	Employee ID of the creator
`updatedBy`	5	number	Employee ID of the last editor

You can reference a system field using either its name (e.g., createdAt) or its ID (e.g., 2).

Filter Structure

All system field filters follow this general structure:

[
	{
		"subject": "<fieldName or fieldId>",
		"type": "<dataType>:systemField",
		"operator": "<operator>",
		"value": <value>
  }
]

System Field Examples

1) AutoId (Text)

[{
  "subject": "autoId",   
  "type": "text:systemField",
  "operator": "like",
  "value": "1234"
}]

You can also use the numeric ID:

[{
  "subject": "1",
  "type": "text:systemField",
  "operator": "equals",
  "value": "447"
}]

2) CreatedAt / UpdatedAt (Datetime)

[{
  "subject": "createdAt",   
  "type": "datetime:systemField",
  "operator": "on_or_after",
  "value": {
    "relative": true,
    "type": "TODAY"
  }
}]

Using IDs:

[{
  "subject": "3",   
  "type": "datetime:systemField",
  "operator": "before",
  "value": {
    "relative": true,
    "type": "YESTERDAY"
  }
}]

3) CreatedBy / UpdatedBy (Number)

[{
  "subject": "createdBy",   
  "type": "number:systemField",
  "operator": "equals",
  "value": 12341234
}]

Using IDs:

[{
  "subject": "5",   
  "type": "number:systemField",
  "operator": "equals",
  "value": 987654
}]