_id (Primary Key)
objectid
The unique identifier for the record
| Requires a Non-Null Value | Yes |
key Input Key
string
The property of the database record to evaluate. Uses dot notation conventions.
| Requires a Non-Null Value | Yes |
| Default Value | "" |
| Trims Whitespace | No |
| HTML Tags Allowed | No |
| Converts to Lowercase | No |
| Converts to Uppercase | No |
queryOperator Operator
options
The logical operator that determines how the value of the property will be compared against the value supplied in the condition.
| Requires a Non-Null Value | Yes |
| Allowed Values | | $eq | The property must be equal to the condition value. | | $ne | The property must be different from the condition value. | | $lt | The property must evaluate to a number and must be less than the condition value which also must evaluate to a number. | | $gt | The property must evaluate to a number and must be greater than the condition value which also must evaluate to a number. | | $lte | The property must evaluate to a number and must be less than or equal to the condition value which also must evaluate to a number. | | $gte | The property must evaluate to a number and must be greater than or equal to the condition value which also must evaluate to a number. | | $in | The property must contain the condition value. | | $nin | The property must exclude the condition value. |
|
| Default Value | $eq |
value Value
string
The value will be compared against the database using the designated operator.
| Requires a Non-Null Value | Yes |
| Default Value | "" |
| Trims Whitespace | No |
| HTML Tags Allowed | No |
| Converts to Lowercase | No |
| Converts to Uppercase | No |
parentProcess Parent Process
objectid
A reference to the process that owns this field record.
| Requires a Non-Null Value | No |
projectId
objectid
A reference to the project that owns this field record.
| Requires a Non-Null Value | Yes |
accountId
objectid
A reference to the account that owns this field record.
| Requires a Non-Null Value | Yes |
createdTime
datetime
System managed property. Set to the timestamp of when the record is created.
| Requires a Non-Null Value | Yes |
| Default Value | __auto__ |
modifiedTime
datetime
System managed property. Set to the timestamp of when the record is updated.
| Requires a Non-Null Value | Yes |
| Default Value | __auto__ |