Create “OR” statements in text mode filters

You can include multiple statements when you create a filter in lists and reports.

For information about creating filters, see the following articles:

Text Mode filter operators

For information about Adobe Workfront filter operators in the standard filter interface, see Filters overview.

Workfront has 2 filter operators that connect each filter statement:

  • AND: When you join 2 filter statement by the AND operator you indicate that you want both filter statements to be met at the same time.

    By default, the statements in a filter are joined by the AND operator.

    When building an AND filter in the text mode interface, you don’t need to use the AND operator. It is assumed.

    Example: To filter for tasks that have a Planned Completion Date of Today and a Percent Complete lower than 100% use the following text mode code:

    plannedCompletionDate=$$TODAY
    
    plannedCompletionDate_Mod=eq
    
    percentComplete=100
    
    percentComplete_Mod=lt
    
  • OR: When you join 2 filter statements by the OR operator you indicate that you want either statement to be met.

    note tip
    TIP
    When changing your AND statements to OR statements, the number of the items in your report should increase.

    When building an OR filter using the text mode interface, you must use the OR operator.

    Example: To filter for tasks that have a Planned Completion Date of Today or a Percent Complete lower than 100% use the following text mode code:

    plannedCompletionDate=$$TODAY
    
    plannedCompletionDate_Mod=eq
    
    OR:1:percentComplete=100
    
    OR:1:percentComplete_Mod=lt
    

Text Mode syntax for OR filters

The text mode syntax for an OR filter must contain the following:

  • The OR operator followed by a colon, a number, and another colon at the beginning of each filter line that refers to the object in the OR statement. This includes the line that references the filter field or attribute and the line that references the filter modifier.

    Follow this pattern when building an OR filter:

    =
    
    _Mod=
    
    OR:1:=
    
    OR:1:_Mod=
    
    note tip
    TIP
    The OR operator is case sensitive and it is always uppercase.

    You may have multiple OR statements in a filter. In this case, every OR statement receives a number, in the order you want the statements applied.

    Example: To filter for tasks that have a Planned Completion Date of Today OR a Percent Complete lower than 100% OR a Status of New use the following text mode code:

    plannedCompletionDate=$$TODAY
    
    plannedCompletionDate_Mod=eq
    
    OR:1:status=NEW
    
    OR:1:status_Mod=in
    
    OR:2:percentComplete=100
    
    OR:2:percentComplete_Mod=lt
    
  • The name of the fields or the attributes you reference in a filter must be written in camel case. For information about camel case, see Text mode syntax overview.

  • When you refer to custom fields in an OR filter, you must insert DE: between the OR modifier syntax and the name of the custom field. You must spell the name of the custom field as it appears in the Workfront interface.

    Example: To filter for tasks that have a Status of New OR a Percent Complete lower than 100% OR a custom field called “Account Type” with a value of “Equal”, use the following text mode code:

    status=NEW
    
    status_Mod=in
    
    OR:1:percentComplete=100
    
    OR:1:percentComplete_Mod=lt
    
    OR:2:DE:Account Type=Capital
    
    OR:2:DE:Account Type_Mod=in
    
recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43