Here is the problem statement:
I am implementing a search service - taking any keyword as the input. It will be doing the search on all the content at certain path.
The search results should show the keyword is in the Tag, it should come on the top.
Question : Using JCR SQL2, how to bring the search result with keyword match on the top ?
Any suggestions will be highly appreciated.
SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE([/content/geometrixx-outdoors/en]) and s.[cq:tags] like '%apparel%'
Thanks Hemant. But my problem statement is different.
Let's consider an example:
1. Keyword search under certain path, say '/content/geometrixx-outdoors'
2. Search Results will look like this:
a.Results matching the keyword in the tags - they should come on top of the results.
b. Results matching anywhere else other than tags.
Question: How to have the search results on the top if they match the tags, than other results ?
try this SELECT s.[cq:tags] FROM [nt:base] AS s WHERE ISDESCENDANTNODE([/content/geometrixx-outdoors/en]) and s.[cq:tags] = 'geometrixx-outdoors:season/winter' ORDER BY s.[cq:tags] DESC I changed the position to last of geometrixx-outdoors:season/winter tag on one of the pages I ran this query and I see pages with geometrixx-outdoors:season/winter tag on 3rd position appears last