Forum Discussion

Boja's avatar
Boja
Icon for Advocate II rankAdvocate II
7 years ago

Visual for multi-word text search

Hi guys,   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 ma...
Tutorial Requests
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

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")
Boja's avatar
Boja
Icon for Advocate II rankAdvocate II
7 years ago

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?

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Boja  use custom filters like 'smart filter' or 'text filter'  and assign that 'comments'  field to it.  Any visual u need to assign a filed to it right