Workflow Query Conditions
In the workflow query builder, after you choose the area of the workflow that you are querying, you must choose a condition related to that area. The following tables define the available conditions for each area of the workflow.
File Conditions
| Condition | Description | Example |
|---|---|---|
| path equals | Checks if the filename with its full path is/is not this value. | If the full file path is /myuser/mydir/myfile.pdf |
| Parent path equals | Checks if the directory of the file is/is not this value. | If the file's directory is /myuser/mydir |
| extension is | Checks if the file extension is/is not this value. | If the file extension is txt |
| size is | Checks if the file size falls within the range indicated. | If the file size is > 100000 or < 500000 in bytes |
| owner is | Checks if the file owner is/is not the user specified. | If the file owner is aliahberk |
| owner's email is | Checks if the file owner's email is/is not the email specified. | If the file owner's email is aliahberk@example.com |
| path starts with | Checks if the file path begins/does not begin with the directories specified. | If the file's directory starts with /myuser/mydir |
| path contains | Checks if the file path contains/does not contain the folder directory specified. | If the file's directory contains mydir in its path |
| path matches | Checks if the text specified has a match/does not have a match in the file path. | If the file directory has *dir* anywhere in it |
Share Conditions
| Condition | Description | Example |
|---|---|---|
| path equals | Checks if full path of share is/is not this value. | If share path is /myuser/mydir/myfile.pdf |
| type is | Checks if share is/is not public or private. Valid values are public and private. | If share is public |
| created by | Checks if the share owner is/is not the user specified. | If the share owner is jaredmc |
| created by user with email | Checks if the share owner's email is/is not the email specified. | If the share owner's email is jaredmc@example.com |
| is public | Checks if the share is/is not public | If is public = False (if the share is private) |
| is directory | Checks if the share is a file or folder | Is Share is directory = True (if share is a folder) |
| allowed users contains email | Checks if the users added to the share include this email | If users added to share include maurap@example.com |
| allowed groups contains group | Checks if the groups added to the share included this group | If groups added to share include Accounting |
| users contains email domain | Checks if the users added to the share include/do not include this email domain | If users added to share include the email domain gmail.com |
| users are ONLY from domain | Checks if the users added to the share are only/are not only from the email domain | If users added to share are only from the email domain verizon.com |
| path starts with | Checks if the share path begins/does not begin with the directories specified. | If the share path's directory starts with /myuser/mydir |
| path contains | Checks if the share path contains/does not contain the folder directory specified. | If the share path's directory contains mydir in its path |
| path matches | Checks if the text specified has a match/does not have a match in the share path. | If the share path's directory has *dir* anywhere in it |
User Conditions (User is user who created the workflow)
| Condition | Description | Example |
|---|---|---|
| User name is | Checks if the workflow creator's username is/is not this value. | If the workflow creator's username is aliahberk |
| User email is | Checks if the workflow creator's email is/is not this value. | If the workflow creator's email is aliahberk@example.com |
| User type is | Checks if the workflow creator's user type is/is not this value. Valid values are Full Access, Limited Access, and Guest Access. | If the workflow creator's user type is Full Access. |
| User's last logged is | Checks if the workflow creator's last log-in date is prior to the value indicated. | If the workflow creator's last log-in date is <2023-08-30 |
| User's total storage in GB is | Checks if the workflow creator's total storage in GB is greater than the specified value. | If the workflow creator's total storage is >100GB |
| User is part of group | Checks if the workflow creator is\is not part of the group specified. | If the workflow creator is part of the Accounting group. |
| User's email domain is in | Checks if the workflow creator's email domain is\is not the domain(s) specified | If the workflow creator's email domain is not gmail.com |
Startedby Conditions (Startedby is the user who performed the action that triggered the workflow)
| Condition | Description | Example |
|---|---|---|
| Started by User name is | Checks if the startedby user's username is/is not this value. | Checks if the startedby user's username is jaredmc |
| Started by User email is | Checks if the startedby user's email is/is not this value. | If the startedby user's email is jaredmc@example.com |
| Started by User type is | Checks if the startedby user's user type is/is not this value. | If the startedby user's user type is Full Access, Limited Access, or Guest Access |
| Started by User's last logged is | Checks if the startedby user's last log-in date is prior to the value indicated. | If the startedby user's last log-in date is <2023-08-15 |
| Started by User's total storage in GB is | Checks if the startedby user's total storage in GB is greater than the specified value. | If the startedby user's total storage is > 200GB |
| Started by User is part of group | Checks if the startedby user is\is not part of the group specified. | If the startedby user is part of the Marketing group. |
| Started by User's email domain is in | Checks if the startedby user's email domain is\is not the domain(s) specified | If the startedby user's email domain is mycompany.com |
Metadata Conditions
| Condition | Description | Example |
|---|---|---|
| Exists for the file | Checks if the metadata and metadata attribute specified exist/do not exist for this file or folder. | If cce.pii exists as a metadata group and attribute. |
| Exists for the file with value | Checks if the metadata and metadata attribute with the given value exist/do not exist for this file or folder. | If cce.pii exists and is equal to yes |
| Exists for the file with value in array | If the metadata and a metadata attribute with one of the values in the array exist/do not exist for this file or folder. | If cce.pii exists and is equal to one of the following: yes, y, unknown |
| Exists for the file that matches the following condition | If the metadata and a metadata attribute matching the condition given exist/do not exist for this file or folder. | if invoice.amount exists and is > 500 |
Var Conditions
| Condition | Description | Example |
|---|---|---|
| <var name> matches | If the value of the variable is equivalent/is not equivalent to the value(s) indicated. | If filecount > 1000 |
If Var current date matches
This condition only applies to the trigger Started based on a timer. The condition is already defined as if Var Current date matches and no other conditions may be selected.
Ctx Conditions
| Condition | Description | Example |
|---|---|---|
| Current date matches | If the current date is equivalent/is not equivalent to the value(s) specified. | If the current date is StartDate |
| Current date and time matches | If the current date is equivalent/is not equivalent to the value(s) specified. | If the current date and time is greater than StartDateTime and less than EndDateTime |
| Workflow Name matches | If the workflow name matches/does not match the name specified. | If the workflow name is CreateDirectory |