Smart search filter NULL and LIKE

Anikesh Das asked on November 21, 2014 06:15


I’ve implemented smart search in my page which performs the search on CMS.News, CMS.Offices, CMS.Products. I have added a text field named “Sites” to all 3 page types and made this field Searchable and Tokenized for all above page types.

Now I want to add a filter on my search like below

Sites IS NULL OR LEN(Sites) = 0 OR ';' + Sites + ';' LIKE '%;XYZ;%'"

Can you please let us know how we can achieve this?

Recent Answers

Roman Koníček answered on November 30, 2014 10:32


Could you please describe me your requirement in more detail? What is the expected result? Is it possible to give me some simple example of filtering so I have a better understanding? Also I would recommend you to check smart search filter in our documentation.

Regards, Roman Konicek

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.