Search and Filter Widget
jjmcm123 said 1 year ago:
Can a search and filter widget be configured to find just keywords in a database field? example – the search is entered as a narrative such as “I am looking for a red bike” and the filter would return a record that matches the keywords “red” and “bike” and ignores the rest of the words (I, am, looking, for, a).
christianh said 1 year ago:
@jjmcm123
It will not work like this. It would need to be searched just using the keywords.
–Christian
chriss said 1 year ago:
Hello,
It is a common practice in natural language searching to remove common English words, this is to prevent a phrase like “Cookies and Cream” from returning Results containing phrases like “Potatoes and Gravy” due to the common English word “and”.
The complete list of words our search system blocks is as follows:
“a”, “an”, “and”, “are”, “as”, “at”, “be”, “but”, “by”,
“for”, “if”, “into”, “is”, “it”, “no”, “not”, “of”, “on”, “such”,
“that”, “the”, “their”, “then”, “there”, “these”,
“they”, “this”, “to”, “was”, “will”, “with”
DS said 1 year ago:
Hello @jjmcm123,
There are also some advanced searching options available.
* – is a wildcard, so use it search for bik* and it may return results like bike, bikes, biking, etc.
~ – is a fuzzy search, so use it to search for byke~ and it may return results like bike, bic, bikes, etc. It’s good for when you’re not sure how to spell something.
OR – will return all results with one word or another, so “Red” OR “Bike” should return all rows that have the words red or bike.
AND – will return all results with both words, so “Red” AND “Bike” should return all rows that have the words red and bike.
Maybe you can include some tips like that in the instructions?
Let me know if that was helpful,
DS
3 min expected wait time