Expand my Community achievements bar.

AEM 6.2 - Query Parsing Issue

Avatar

Level 2

Hi All,

I have following query:

group.1_group.1_group.path=/content/dam/public/en_us/ext
group.1_group.2_group.path=/content/dam/public/en_us/pdfs
group.1_group.p.or=true
group.2_group.1_group.type=cq:Page
group.2_group.2_group.type=dam:Asset
group.2_group.p.or=true
group.3_group.2_group.fulltext=marketing:interest/product
group.3_group.2_group.fulltext.property=@jcr:content/cq:tags
group.3_group.1_group.1_group.fulltext=marketing:interest/product
group.3_group.1_group.1_group.fulltext.property=@jcr:content/metadata/cq:tags
group.3_group.1_group.2_group.fulltext=marketing:interest/services
group.3_group.1_group.2_group.fulltext.property=@jcr:content/metadata/cq:tags
group.3_group.1_group.p.and=true
group.3_group.p.or=true

 

and this query is parsed as :

SQL2: select [jcr:path], [jcr:score], * from [cq:Page] as a where [jcr:primaryType] = 'cq:Page' and contains(*, 'marketing:interest/product') and contains(*, 'marketing:interest/services') union select [jcr:path], [jcr:score], * from [cq:Page] as a where [jcr:primaryType] = 'cq:Page' and contains(*, 'marketing:interest/product') union select [jcr:path], [jcr:score], * from [dam:Asset] as a where [jcr:primaryType] = 'dam:Asset' and contains(*, 'marketing:interest/product') and contains(*, 'marketing:interest/services') union select [jcr:path], [jcr:score], * from [dam:Asset] as a where [jcr:primaryType] = 'dam:Asset' and contains(*, 'marketing:interest/product') 

xpath: //*[((((@jcr:primaryType = 'cq:Page')) or ((@jcr:primaryType = 'dam:Asset'))) and (((jcr:contains(., 'marketing:interest/product')) and (jcr:contains(., 'marketing:interest/services'))) or (jcr:contains(., 'marketing:interest/product'))))] */

 

This query do the fulltext searhc in all properties. It doesn't search in cq:tags specifically.

Any idea about this issue? Any kind of help would be highly appreciated.

Thanks !!

0 Replies