AEM Query not showing correct results after service pack upgrade to 6.5.12

Question

Hi Team,

After upgrading AEM service pack (from 6.5.6 to 6.5.12) we are not get correct search results from Query Builder.

I am running the below query to get all the 'RUNNING' workflows from AEM

http://localhost:4502/bin/querybuilder.json?path=/var/workflow/instances&1_property=modelId&1_property.value=/var/workflow/model/launchworkflow&2_property=status&2_property.value=RUNNING&3_property=jcr:PrimaryType&3_property.value=cq:workflow&orderby=path

Before(AEM 6.5.6) the upgrade we use to get the results. Post upgrading service pack to 6.5.12 I'm getting results as 0.

Unable to see any errors in com.day.cq.search log file.

Anyone any idea why results might not be coming after upgradation.?

Thanks,

pulkitvashisth · Accepted Answer

Hi @girishb83316758
Have you tried reindexing the relevant oak indexes after the service pack upgrade?
https://blogs.perficient.com/2017/04/19/rebuild-indexes-in-aem-with-oak-index-manager/
Also check if the modelId you are using exists now after the upgrade.

Saravanan_Dharmaraj · Answer

@girishb83316758 I see typo and camelCase mismatch in the query. I just the ran the below query similar to yours it works fine. Bold ones are wrong in your query.

path=/var/workflow/instances
1_property=modelId
1_property.value=/var/workflow/models/<MODELID>
2_property=status
2_property.value=RUNNING
3_property=jcr:primaryType
3_property.value=cq:Workflow
orderby=path

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded