Filters are not working when using multiple "AND" conditions | Community
Skip to main content
H
Himanshu4
Level 2
March 20, 2025
Solved

Filters are not working when using multiple "AND" conditions

  • March 20, 2025
  • 1 reply
  • 452 views

Hi,

 

I am unable to filter the data using multiple "AND" conditions in workfront fusion, Its working with only one "AND" condition and not with 2 or 3 conditions. 

Any one has any idea if there is a way to do that? or Is it not possible to use two "AND" conditions in a fusion scenario?  Attaching a screenshot for reference

 

 

 

Any suggestion or help would be highly appreciated. TIA

 

 

Best answer by Sven-iX

Ah - then you need to change it to 

  • if Event date is less than 5 days AND Event Name is equal to Canada 
    OR
  • if Event date is less than 5 days AND Event Name is equal to Japan

1 reply

Sven-iX
Community Advisor
Sven-iXCommunity Advisor
Community Advisor
March 20, 2025

The filter will only pass a bundle if a bundle meets all the AND conditions. In your case you can see it does not meet 2 of the conditions so it doesn't pass. 

 

Can you spell out in English the expected logic?  like "If XXXX equals YYYY and ZZZ doesn't contain bbb.... etc. 

And provide the case that you think should go through but is not.

I don't understand the 1 part of the filter:  5 days before = 5 days before ?

 

 

H
Himanshu4Author
Level 2
March 20, 2025

@sven-ix  Thank for looking into it. The logic I am trying to create is if Event date is less than 5 days and Event Name is equal to Canada and Japan only then it should pass through it.

Sven-iX
Community Advisor
Sven-iXCommunity AdvisorAccepted solution
Community Advisor
March 20, 2025

Ah - then you need to change it to 

  • if Event date is less than 5 days AND Event Name is equal to Canada 
    OR
  • if Event date is less than 5 days AND Event Name is equal to Japan
    Terms & ConditionsAccessibility statement

    Loading footer...