Boosting at field/property level in case of jcr sql2 versus Querybuilder

You can set the boost property in the index configuration for properties which would you like to have higher search relevancy. See the Boost and Search relevancy documentation here - 

`https://jackrabbit.apache.org/oak/docs/query/lucene.html#boost 

Hi Kunal,

Thank you for your reply.

The article you mentioned provides details on boosting the page properties, by making some configuration changes. However, the problem is initially the code for boosting was written via jcr-sql2 query and we will have to achieve this by means of code itself.

So, wondering if there is a way it can be done via Query Builder way or jcr-sql2 is the only option.

Any thoughts here would be helpful.

Well I did not understand your question completely. But the run time boosting is indeed supported by jcr contains function - https://helpx.adobe.com/experience-manager/kb/BoostInSearch.html

Hi Kunal,

Sorry for not being clear. 

This in is continuation to the query posted [http://help-forums.adobe.com/content/adobeforums/en/experience-manager-forum/adobe-experience-manager.topic.1.html/forum__kvub-hi_all_we_havea.html ], on which you have been guiding me.

Now, looks like with the below query

SELECT * FROM [cq:Page] AS parent INNER JOIN [nt:base] As s ON ISDESCENDANTNODE(s,parent) WHERE ISDESCENDANTNODE(parent,[/content/x/y]) AND (CONTAINS(s.[cq:tags],'ABC*^600') OR CONTAINS(s.blocktitle,'ABC*^400')  OR CONTAINS(s.bodycopy,'ABC*^100')  OR CONTAINS(s.headingText,'ABC*^10') OR  CONTAINS(s.Author,'ABC*^400')  OR CONTAINS(s.headline,'ABC*^2')  OR CONTAINS(s.[jcr:title],'ABC*')  OR CONTAINS(s.[cq:tags],'DEF*^600') OR CONTAINS(s.blocktitle,'DEF*^400')  OR CONTAINS(s.bodycopy,'DEF*^100')  OR CONTAINS(s.headingText,'DEF*^10')  OR CONTAINS(s.Author,'DEF*^400') OR  CONTAINS(s.headline,'DEF*^2') OR CONTAINS(s.[jcr:title],'DEF*'))  AND ( NOT parent.[hideInSearch] IS NOT NULL) ORDER BY parent.[jcr:lastModified]

a] Things are working fine for multiple keyword search[fulltext and partial].

b] Only thing is that its a bit slow. So, we were wondering if the same thing can be converted to a Query builder approach one?

Agreed - this is a complex query (you have a lot of OR conditions) and the performance will take a hit. 

Hi Kunal,

Thank you for your reply.

Sorry for not being clear.

The question I had was 

a] In the query posted in this thread above, boosting is done by making use of JCR-SQL2.

b] So, is boosting property values possible only via JCR-SQL2 or via Quer builder approach too?

c] If possible via Query builder approach too, can you please provide any pointers/reference code for the same.

Any thoughts on this will be helpful.