12-05-2018 08:07 AM
The Custom Visual Text Filter by Microsoft allows searching based on a phrase. If I type for example "video voice", it will search the input as a phrase not separate words.
Is there maybe a visual like a Text Search that can search based on several key words? Is there a visual with something like lucene syntaxe so I can search with "video + voice" ?
thank you for brainstorming
12-05-2018 08:47 AM
I think you could use something like:
Column = VAR __first = SEARCH("video",[Column],1,0) VAR __second = SEARCH("voice",[Column],1,0) RETURN IF(__first = 0 || __second = 0,"Not Found","Found")
Did I answer your question? Mark my post as a solution!
Proud to be a Datanaut!
12-05-2018 08:52 AM
Thank you for wuick reply, @Greg_Deckler.
The solution is a good for a custom column. However, I need a visual in a form of a search box, so users can search comments based on keywords they put in. Do you maybe have something on your mind?
12-05-2018 11:28 PM
12-07-2018 01:08 AM
It's a good idea, but it wont work in my case. The field that user are searching in contains customer feedback (very long sentences). But thank you for thinking through.