Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Unable to perform fulltext search operation over multiple path

Avatar

Community Advisor

Hi ,
I am trying to perform fulltext search operation over multiple path.Here, we have two different paths and both are different type as well.
 I have tried to implement  it with querybuilder. Below, I have mentioned the query -
 fulltext=Tools
group.p.or=true
group.1_path=/content/awsportal/en/cashcard
group.1_type=cq:Page
group.2_path=/content/dam/awsportal/resources
group.2_type=dam:Asset
group.2.1_property=jcr:content/metadata/jcr:usergroup
group.2.1_property.value=CCUser
group.2.2_property=jcr:content/metadata/jcr:companyid
group.2.2_property.value=CASHCARD
group.2.3_property=jcr:content/metadata/jcr:externalappusr
group.2.3_property.value=DAApp

Here,  group.1_path=/content/awsportal/en/cashcard, is the location of  webpages , as I have mentioned the type cq:Page and group.2_path=/content/dam/awsportal/resources is the location for digital assets. We have implemented 3 properties here, jcr:usergroup, jcr:companyid & jcr:externalappusr on the group.2 i.e digital assets .

Corresponding to above mentioned properties , we have 3 metadata as well usergroup, companyid & externalappusr and their values are also available in the repository also. But, after the search operation , we are not getting proper result and the query generated by querybuilder doesn't consider these properties .

If I try to implement single path with its properties using query builder(digital assets location with its properties) , in that case I am getting proper result.

One more thing is that, is it possible to implement multile path in CQ5 xpath query or SQL query?

Please suggest .

Thanks,

Debal Das

1 Accepted Solution

Avatar

Correct answer by
Level 10

Yes -- you can implement multiple path searches using the JCR SQL2. For example:

SELECT * FROM [nt:unstructured] WHERE someProp = 'white dog' 

                                  AND someProp = 'black dog'

This may be a better way to go for your use case. See this Stackoverflow thread for more information:

http://stackoverflow.com/questions/7968464/jcr-sql2-multivalue-properties-search

And this link:

http://www.day.com/specs/jcr/2.0/6_Query.html#6.7.16%20Comparison

To see a community article that talks about using AEM and JCR-SQL2 -- see:

http://scottsdigitalcommunity.blogspot.ca/2013/02/querying-adobe-experience-manager-data.html

Hope this helps

View solution in original post

5 Replies

Avatar

Correct answer by
Level 10

Yes -- you can implement multiple path searches using the JCR SQL2. For example:

SELECT * FROM [nt:unstructured] WHERE someProp = 'white dog' 

                                  AND someProp = 'black dog'

This may be a better way to go for your use case. See this Stackoverflow thread for more information:

http://stackoverflow.com/questions/7968464/jcr-sql2-multivalue-properties-search

And this link:

http://www.day.com/specs/jcr/2.0/6_Query.html#6.7.16%20Comparison

To see a community article that talks about using AEM and JCR-SQL2 -- see:

http://scottsdigitalcommunity.blogspot.ca/2013/02/querying-adobe-experience-manager-data.html

Hope this helps

Avatar

Level 10

You are doing a full text on Tools  & make sure the parameter are right & it will work.   Note multiple root paths executing can be very slow if there are not much other constraints in the query.   Attaching the snapshot for your reference.

[img]DAM.png[/img]

[img]Debug.png[/img]

Avatar

Community Advisor

Hi ,

Thanks for the reply. Could you please explain multipath fulltext search with 1 example?

What should be the query? Please consider the paths from my previous question.

 

Thanks,

Debal

Avatar

Level 10

Here is another community page that may be of help:

http://www.sfu.ca/itservices/cms/howto/advanced/organize-and-optimize/advanced-queries.html

This page discusses advanced Query Builder queries.

I will be discussing with the AEM documentation team about getting more advanced Query Builder examples into the AEM documentation. I am also investigating if there is known Query Builder bug with CQ 5.5. 

Avatar

Level 10

Based on our conversion on the other social channel and your results -- please open a day care ticket. See http://helpx.adobe.com/marketing-cloud/contact-support.html.