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.

Need help on search querying both pages and assets and if assets then search their title etc

Avatar

Level 3

Dear All,

I am facing a strange issue. I am using querybuilder api to search in our website. Requirement is to search both page and assets on a specific paths and if its asset then look for specific types only like PDF or word etc and look for the search term in title or description.

I have build the query properly and the predicates looks like below,

fulltext=Ravi
mainasset=true
1_group.1_group.path=/content/<folder>
1_group.2_group.path=/content/dam/<folder>
1_group.p.or=true


2_group.1_group.type=cq:Page
2_group.2_group.type=dam:Asset
2_group.p.or=true

2_group.2_group.1_property=jcr:content/metadata/dc:format
2_group.2_group.1_property.1_value=application/vnd.ms-excel
2_group.2_group.1_property.2_value=application/pdf
2_group.2_group.1_property.3_value=application/vnd.ms-word
2_group.2_group.1_property.4_value=application/msword
2_group.2_group.1_property.5_value=application/vnd.openxmlformats-officedocument.wordprocessingml.document

2_group.2_group.5_group.2_property.operation=like
2_group.2_group.5_group.2_property=jcr:content/metadata/dc:description
2_group.2_group.5_group.2_property.1_value=%Ravi%
2_group.2_group.5_group.3_property.operation=like
2_group.2_group.5_group.3_property=jcr:content/metadata/cq:tags
2_group.2_group.5_group.3_property.1_value=%Ravi%
2_group.2_group.5_group.4_property.operation=like
2_group.2_group.5_group.4_property=jcr:content/metadata/dc:title
2_group.2_group.5_group.4_property.1_value=%Ravi%
2_group.2_group.5_group.p.or=true

orderby.sort=desc
p.offset=0
p.limit=10
p.hits=selective

This query works fine in my local instance however the same query does not work in our other environments. If I remove the block 

2_group.1_group.type=cq:Page
2_group.2_group.type=dam:Asset
2_group.p.or=true 

and just put type=dam:Asset  the query fetches the document, when I OR it with page it does not work. Do anyone have any idea on this? Please help.

4 Replies

Avatar

Administrator

Hi 

Moving this thread to AEM "Asstes" topic so to have better contextual experts have a look at this.

~kautuk



Kautuk Sahni

Avatar

Level 4

Hi,

Is the server using mongo db ? Since the query works on local which I assume is TarMK and is not working in other environments.

Regards,

Ashwin Raju

Avatar

Level 3

Hi Ashwin,

Its same on all environments - TarMk.

Avatar

Level 3

Hi Ashwin,

Its same on all environments - TarMk. We are no using MongoDB