fieldName | String Name of the field for which you specify the filter criteria. The column names can be: ![]() ![]() For the list of valid values, see List of Column names. |
isOrQuery | String Whether the join condition for the filter criteria in the criteria variable is AND or OR. Valid values for the JOIN condition: ![]() ![]() |
criteria | Document List The filter criteria. Each field can have more than one filter criteria. For example, UserStatus IS NULL AND UserStatus = IGNORED, where UserStatus is the field name, IS NULL and '=' are the operators, AND is the join condition, and IGNORED is the value. Each document in the document list contains the following variables: ![]() For the list of valid values based on the field types, see Valid Values for the criteria field
variable. ![]() For example, for the filter criteria, 'UserStatus = IGNORED', UserStatus is the field name, '=' is the operator, and IGNORED is the value. If you specify a sub-query (dynamicCriteria), then to specify the join condition for the sub-query, the values are 'DynamicGlobalOR' or 'DynamicGlobalAND'. ![]() The fieldName variable must be either SenderID or ReceiverID. The operator value for the parent criteria must be Dynamic. The sub-query is added to SenderID or ReceiverID, based on what value you provided in the fieldName. If the value of receiverEqualsSender is true, then the sub-query is added to both SenderID and ReceiverID. For the list of variables for each document, see Variables for dynamicCriteria
variable. |
Query Type... | Column names... |
Document Query | ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Event Query | ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Task Query | ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Profile Query | ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Field Types | Field Values |
STRING | ![]() ![]() ![]() ![]() |
NUMBER | ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
DATETIME | ![]() ![]() ![]() ![]() ![]() |
DATETIME LIST | ![]() ![]() |
NUMBER LIST or STRING LIST | ![]() ![]() ![]() |
Value | Description |
fieldName | String Name of the field for which you specify the sub-query filter criteria. For the list of valid values, see the values corresponding to Profile Query in the fieldName parameter. |
isOrQuery | String Whether the join condition for the filter criteria in simpleCriteria is AND or OR. You can set the following values for the JOIN condition: ![]() ![]() |
simpleCriteria | Document List The filter criteria for a field in the sub-query. Each field can have more than one filter criteria. For example, 'GroupName IS NULL' OR 'GroupName <> G1' where GroupName is the field name, IS NULL and <> are the operators, OR is the join condition, and G1 is the value. Each document in the document list contains the following variables: ![]() ![]() ![]() ![]() ![]() ![]() 'GroupName < > G1', G1 is the value |