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
Solved! Go to Solution.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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]
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies