Querybuiler is not giving correct result in publish instance | Community
Skip to main content
Level 2
December 29, 2020
Solved

Querybuiler is not giving correct result in publish instance

  • December 29, 2020
  • 3 replies
  • 1840 views

Hi,

 

I have tried searching for pages which contain a particular tag, querybuilder of author instance is giving accurate results, whereas publish instance is not giving required results with the same query.

 

Note: pages and tags are replicated and when I search pages of other tags, they are working fine but pages of particular tag are not showing correct results.

 

Thanks in advance.

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 Kunal_Gaba_

Few things you can check to debug the issue- 

  1. The permissions or ACLs are appropriate for the new tag and the end user have read access to the tags on publish instance. 
  2. Use the query performance tool and click on "Explain Query" function to find out if the query with new tag is using the same index and have the same execution plan. 
  3. Check the publisher logs when you run the query and also when you publish the page with new tags. You should not see any indexing errors or any errors while running the query.

3 replies

Kunal_Gaba_
Kunal_Gaba_Accepted solution
December 29, 2020

Few things you can check to debug the issue- 

  1. The permissions or ACLs are appropriate for the new tag and the end user have read access to the tags on publish instance. 
  2. Use the query performance tool and click on "Explain Query" function to find out if the query with new tag is using the same index and have the same execution plan. 
  3. Check the publisher logs when you run the query and also when you publish the page with new tags. You should not see any indexing errors or any errors while running the query.
shelly-goel
Adobe Employee
Adobe Employee
December 30, 2020

@himasreep445197 

If not already verified, please check if the pages that are not coming up in the results have the cq:tag property set with the expected tag in publish crxde. If the tags are present on those pages as expected and you've not created any custom indexes, re-indexing on 'cqTagLucene' might help.

Shubham_borole
Community Advisor
Community Advisor
January 3, 2021

Hi,

 

Can you please provide the query that is used? I had noticed difference in results when looking with type cq:Page vs looking for jcr:content nodes of pages with given query criteria. May be this is similar issue

:

Level 2
January 4, 2021

Hi

Please find the query below

path=/content/----

type=cq:Page

1_property.1_value=tagname

1_property=jcr:content/cq:tags

1_property.and =true

orderby.index=true

p.limit=-1

 

Thank you