Unable to perform fulltext search operation over multiple path | Community
Skip to main content
DEBAL_DAS
DEBAL_DAS
New Participant
October 16, 2015
Solved

Unable to perform fulltext search operation over multiple path

  • October 16, 2015
  • 5 replies
  • 1485 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by smacdonald2008

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

5 replies

smacdonald2008
smacdonald2008Accepted solution
New Participant
October 16, 2015

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

Sham_HC
Sham_HC
New Participant
October 16, 2015

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]

DEBAL_DAS
DEBAL_DASAuthor
New Participant
October 16, 2015

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

smacdonald2008
smacdonald2008
New Participant
October 16, 2015

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. 

smacdonald2008
smacdonald2008
New Participant
October 16, 2015

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.

Terms & ConditionsAccessibility statement

Loading footer...