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.
|
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.
|
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 |