How to search the text having space character in search condtion of smart search?

Hi Prashant,

You can search it by adding escape '\' character, f.e.:

+status:(Not\ Accredited)

or

+status:"Not Accredited"

And make sure that you are using appropriate Analyzer type (f.e. White space or something...).

Can you verify is that field that you want to search exist in you search index? Go to search fields and verify that you checked 'content' and 'searchable' on that status field. Also, you can use Apache Lucene to see exactly indexed fields inside indexer.

Smart search index by default contains skuinternalstatusid (i.e. internal status) and skupublicstatusid (i.e Public status) I am assuming you want to get products according to one of those: so for exmaple to get bestsellers you can do +skupublicstatusid: (int)1 internal and public statuses are stored in corresponding tables:

select * from COM_PublicStatus
select * from COM_internalStatus

You have search syntax examples here: NewsTitle:"New features" - returns the news document titled New features.

P.S. if searching some custom field - make sure it is in the index .