Forum Discussion

JennasonQuick_B's avatar
JennasonQuick_B
Qrew Trainee
5 years ago

Expressions in Column Filters

In the new table report, is it possible to use expressions in column filters?

For example, in the column shown below I want to be able to filter alerts where Product code = 04150109468990 or Product Code = 05999540230372?  Is this possible?

Thanks.



------------------------------
Jennason Quick Base Admin
------------------------------
reports and charts
Tables and fields
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    I don't want to test myself as I don't want to get locked into the New Report style just yet, but try entering the search terms or a portion of them separated by OR  in in upper case.

    990 OR 372

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • ScottPugh's avatar
      ScottPugh
      Qrew Cadet
      5 years ago
      Sometimes its so simple :) 

      Thank you.  I had tried lowercase 'or' but never upper.  That appears to be working.

      --
      Scott Pugh
      Jennason LLC | Principal
      Minneapolis, MN | (704)763-0703


      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago

        BTW. When you have a typical filter box on top of a table report you can use syntax in upper case for OR as well as AND




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