Highlighted

Search SQL2 for JCR with Tags

jydps87387977

24-12-2017

Hi,

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.

Search Results

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.

Thanks,

Jay

Replies

Hemant_arora

26-12-2017

SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE([/content/geometrixx-outdoors/en]) and s.[cq:tags] like '%apparel%'

Highlighted

jydps87387977

28-12-2017

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 ?

Highlighted

Hemant_arora

08-01-2018

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