Skip to main content
_Manish_Singh
Level 9
Mar 24, 2023 2:28 PM UTC
Solved

Fusion: Delimiter in filters

How do I separate/delimit multiple project status within a single line without relying on the use of an OR condition? Currently, I'm using OR condition (1 status in each section), but the ask is to mention them in same line using a delimiter. Is this possible? I have tried comma and pipe. Thanks!

 

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
ChrisStephens
ChrisStephensAccepted solution
Community Advisor
Mar 24, 2023 5:10 PM UTC

This works.

 

11 replies

RandyRoberts
Community Advisor
Community Advisor
Mar 24, 2023 3:33 PM UTC

In a report filter, you would use a tab character "CUR" tab "ONH" tab ect.

That may work in Fusion as well. Sometimes it's difficult to insert a tab in a browser based field though as that usually just tabs to the next field.

If tyou test this, please report back so it may help others.

Translate
_Manish_Singh
Level 9
Mar 24, 2023 6:42 PM UTC

After testing I can confirm applying tabs between status doesn't work. Thank you.

Translate
ChrisStephens
Community Advisor
Community Advisor
Mar 24, 2023 5:03 PM UTC

If I recall correctly, you can do it with comma delimiters, and then change Not equal to either "Not In" or "Does not contain", I can't remember which.

Translate
ChrisStephens
Community Advisor
ChrisStephensCommunity AdvisorAccepted solution
Community Advisor
Mar 24, 2023 5:10 PM UTC

This works.

 

Translate
_Manish_Singh
Level 9
Mar 24, 2023 6:44 PM UTC

Amazing.. this works 😁

Translate