Skip to main content
Question

WildCard Search in Tables

  • August 5, 2022
  • 0 replies
  • 279 views
Forum|alt.badge.img+11


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
------------------------------

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • August 5, 2022
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
------------------------------
Mark Shnier. Your Quickbase Coach
MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • December 11, 2024

I think that this is coming on the Dec 15th 2024 release.

https://helpv2.quickbase.com/hc/en-us/articles/32510888999188-Quickbase-December-2024-Release-Notes

Search and reports—wildcard searching

A new query operator, WC (Wildcard), is available in API calls and report builder. It allows you to use an asterisk * or question mark ? as a wildcard character in search strings. This helps you search for relevant information even if you're unsure of the exact spelling or further details.

  • * finds any number of matching characters. For example, Jo? will match Joe and Jon but will not match John, whereas Jo* would also match John.
  • ? finds a single matching character. For example, Jo? will only match John.

 

Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement