Fusion: Delimiter in filters | Community
Skip to main content
_Manish_Singh
_Manish_Singh
Level 9
March 24, 2023
Solved

Fusion: Delimiter in filters

  • March 24, 2023
  • 2 replies
  • 2007 views

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.
Best answer by ChrisStephens

This works.

 

2 replies

RandyRoberts
Community Advisor
RandyRobertsCommunity Advisor
Community Advisor
March 24, 2023

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.

    _Manish_Singh
    _Manish_SinghAuthor
    Level 9
    March 24, 2023

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

    ChrisStephens
    Community Advisor
    ChrisStephensCommunity Advisor
    Community Advisor
    March 24, 2023

    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.

    ChrisStephens
    Community Advisor
    ChrisStephensCommunity AdvisorAccepted solution
    Community Advisor
    March 24, 2023

    This works.

     

      _Manish_Singh
      _Manish_SinghAuthor
      Level 9
      March 24, 2023

      Amazing.. this works 😁

      Terms & ConditionsAccessibility statement

      Loading footer...