Hi Vivek, I remember the biggest challenge I had with fulltext search (lucene) in Jackrabbit was the fact that 'contains' method doesn't work but 'like' works, in the SQL.
Here is my source file that builds the JCR SQL for the fulltext search: https://github.com/Clay-Ferguson/meta64/blob/master/src/main/java/com/meta64/mobile/service/NodeSearchService.java My setup is totally different from yours but the JCR_SQL2 query in that file does work. You should be able to AND it with any other kinds of queries you want, and also use the ISDESCENDANTNODE to target only specific branches of your repository. Best regards, Clay Ferguson wcl...@gmail.com On Sun, Oct 4, 2015 at 9:28 AM, Kesavarajugari, Vivek Kowndinya (US - Bengaluru) <vkesavarajug...@deloitte.com> wrote: > Hi All, > > > > We are trying to create oak indexing for different node types and boost > the values while searching through fulltext query, but it’s not able to > pick it up. > > Could you please suggest the best approach of structuring the query > indexing with multiple node types and property definition. > > > > Attached are the index definition and search query for fulltext > (cq:pages/dam:assets). > > > > Thanks > > Vivek Kowndinya > > > > > > > This message (including any attachments) contains confidential information > intended for a specific individual and purpose, and is protected by law. If > you are not the intended recipient, you should delete this message and any > disclosure, copying, or distribution of this message, or the taking of any > action based on it, by you is strictly prohibited. > > v.E.1 > > > > > > > >
