API v2 Search doesn't work

PerBonomi, Yes you are correct, there is an issue in API v2 for getting the results with matches.

This issue is also there with other API's like labels and tags which have spaces between words.

Hi Parshant , thanks for confirming. Hope we can get this sorted soon.

I'm having issues with the v2 search API too. In fact, it looks like Khoros is suffering the same bad results. If you use the new "Help Center" search in community admin, you probably won't find what you're looking for. I searched for "custom tags" and didn't receive any relevant results.

Thanks for raising the issue tealiumjustin and PerBonomi.  I'm going to follow up with the Search team on this. Some things seemed to have changed. I thought we'd made all the required updates in the documentation, but obviously not. I'll work with our engineers and report back.

Hi PerBonomi tealiumjustin 

There was indeed a change to the LiQL syntax that the Doc team didn't know about. I'm creating a ticket to get our Search API Overview updated.

Here is the response from Engineering:

When we want to return messages that have at least one of these terms in the field we need to enclose in double-quotes.

This will list every post which has any of those terms in the subject field.

select subject,body from messages where subject matches "('attachment','android')"

This will list only those posts which have both terms in the subject field.

select subject,body from messages where subject matches ('attachment','android')

Please let me know if this solves your trouble.

SuzieH Thanks for the quick response! That syntax is a bit unconventional, but it checks out on my end. I'll proceed with this approach.

Indeed, somewhat unconventional, but thanks for chasing that up SuzieH 🙂

And what if you want to add an exact match into the mix? for example adding to the above

"('attachment','android','"apples oranges"')"

Where you want to see results with "apples oranges" but not just "apples". No combination of quotation marks seems to be working for me and the documentation is still wrong.

Thanks

You need to escape the inner double quotes around the term, e.g.

SELECT subject, body FROM messages WHERE subject MATCHES "('banana','potato','\"orange apples\"')"