Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.
SOLVED

Unable to perform fulltext search operation over multiple path

Avatar

Employee 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

Employee 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.