Forum Discussion

KatherineOakey's avatar
KatherineOakey
Qrew Member
3 years ago

Tips and/or tricks to get complex filters in the correct order and grouping

I have a number of fields I want to filter on in a report.

I know how to use and/or and parenthesis to group and filter as I want.

I have fiddled with the filters in this report repeatedly and it seems the biggest challenge is that as I add conditions, figuring out how to get the all/any (and/or) grouping correctly is such a challenge.

Seems like when I add in a new condition, I can't figure out how to get that condition evaluated as I want to sometimes without having to re-add other fields.

Are there any good tips or hints on how to get a complete set of filters/conditions set up in a report?

------------------------------
Katherine Oakey
------------------------------

12 Replies

  • Are you aware that you can indent a set of filters to treat them as an Amy/All block?

    Are you aware that you can use the syntax OR in upper case in a filter. 




    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------

    • KatherineOakey's avatar
      KatherineOakey
      Qrew Member
      Yes, I know you can indent to create a set of ANY/ALL.  

      Not sure that I am aware of using the OR in a filter?

      I usually end up messing up the filters when I try to add a new condition in the middle of the filter someplace.

      ------------------------------
      Katherine Oakey
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        You can have a filter like

        [Subject] contains cats OR dogs OR gerbils 

        The OR must be in upper case.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------