Filter with multiple "Owner/First name" excluded | Community
Skip to main content
J
JoachimFH
Level 2
January 13, 2023
Solved

Filter with multiple "Owner/First name" excluded

  • January 13, 2023
  • 4 replies
  • 1499 views

I try to create a report where I filter off a few names. Please se attached where I want to filter off the names containing traffic or unassigned, but it seems like they keep appearing… And I did try to type it with first letter as a capital as well with the same result.

    Best answer by JoachimFH

    Looking into your various suggestions I found the solution I wanted:

     

    AND:0:owner:firstName=Traffic
    AND:0:owner:firstName_Mod=cinotcontains
    AND:1:owner:firstName=Unassigned
    AND:1:owner:firstName_Mod=cinotcontains

     

    Thank you for your input on this

    4 replies

    Rafal_Bainie
    Community Advisor
    Rafal_BainieCommunity Advisor
    Community Advisor
    January 13, 2023

    explanation is fairly simple.

    Traffic does not contain Unassigned >> so it's in the report

    Unassigned does not contain Traffic >> so it's in the report

    I would look for some other field that could be used to filter out both users at once. Alternatively maybe exist filters could help, but I'm not an expert in this area

    RandyRoberts
    Community Advisor
    RandyRobertsCommunity Advisor
    Community Advisor
    January 13, 2023

    Just use an "AND" instead of an "OR".

     

    There really should be a "NOR" but no coding language has that. What "nor" really means is "and not". But since the "not" part is covered in the "does not contain" part, you only need the "and".

    J
    JoachimFHAuthor
    Level 2
    January 13, 2023

    I started out with using AND instead of OR, but it only takes one of the parameters and when I edit the report afterwards there is only one parameter left. I could probable filter it differently and get the result that I seek for now, but for future reports I am afraid I will miss information I need if can't filter off multiple names

    J
    JoachimFHAuthor
    Level 2
    January 13, 2023

    I found a solution. If I add two prompts for the report (owner/first name on both) I can filter them out.

      Doug_Den_Hoed__AtAppStore
      Community Advisor
      Doug_Den_Hoed__AtAppStoreCommunity Advisor
      Community Advisor
      January 13, 2023

       

      Nice workaround @joachimfh,

       

      I suspect that means the (duplicate) prompts are processed one after the other, "reducing" to your desired data set.

       

      If you'd prefer to NOT have to do the duplicate prompt trick, I invite you to consider this textmode, which allows more than one criteria to be set against the same underlying field (and works similarly for OR):

       

      AND:0:firstName=unassigned
AND:0:firstName_Mod=cinotcontains
AND:1:firstName=traffic
AND:1:firstName_Mod=cinotcontains

       

      Regards,

      Doug

      J
      JoachimFHAuthor
      Level 2
      January 16, 2023

      Thanks for the tip. Unfortunately it didn't work.

      Madalyn_Destafney
      Community Advisor
      Madalyn_DestafneyCommunity Advisor
      Community Advisor
      January 25, 2023

      Hi there, I'd think using AND instead of OR here would work. Instead of 'first name' as you have, try 'assignmentusersMM' to take into account all people assigned to a task. And in text mode can stack them with any other filters you have (I'm using 0 and 1 here but if you already have others you'd change these numbers accordingly).

      AND:0:assignmentsUsersMM:name=traffic
      AND:0:assignmentsUsersMM:name_Mod=cinotcontains

      AND:1:assignmentsUsersMM:name=unassigned
      AND:1:assignmentsUsersMM:name_Mod=cinotcontains

       

      If this helped you, please mark correct to help others : )
      J
      JoachimFHAuthorAccepted solution
      Level 2
      January 26, 2023

      Looking into your various suggestions I found the solution I wanted:

       

      AND:0:owner:firstName=Traffic
      AND:0:owner:firstName_Mod=cinotcontains
      AND:1:owner:firstName=Unassigned
      AND:1:owner:firstName_Mod=cinotcontains

       

      Thank you for your input on this

      Terms & ConditionsAccessibility statement

      Loading footer...