Breadcrumbs

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