Forum Discussion

PrashantMaheshw's avatar
PrashantMaheshw
Qrew Captain
3 years ago

WildCard Search in Tables



Is it possible to do a wild search in regular table view?

Let's say I want to search for 

pras* + eggs
or 
egg + olive


Prashant is my name
Prashant eats eggs with butter
Prashant goes for rock climbing
Prashant makes eggs with olive oil

------------------------------
Prashant Maheshwari
------------------------------
  • np,
    the syntax AND and OR in upper case have meaning as filter operators.

    pras AND eggs

    will give you hits where the search in any columns meet the criteria. The hits do not need to be on the same column.

    pres OR eggs will give more hits as it's an OR operator

    The search is not case sensitive.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • PrashantMaheshw's avatar
      PrashantMaheshw
      Qrew Captain
      Mark , 
      my big fat thanks !!

      ------------------------------
      Prashant Maheshwari
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        ya pretty handy and certainly most regular users would not think to try that.

        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------
    • SaviNewman1's avatar
      SaviNewman1
      Qrew Trainee

      What if we want to search a term that could be spelled multiple ways? 

      Example:

      Adam, or maybe Adam is spelled with a silent "J" so we search "Ad*m" because we're unsure how it's spelt but know it's different and it would pull anything that has "ADM" knowing the Asterix could be anything?

       

      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend

        There isn not native support for wildcards like that.

        One option to note is that you can enter a search terms like

        adam OR adjm  with the OR in upper case.