Querybuiler is not giving correct result in publish instance

[himasreep445197]

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.

[Kunal_Gaba_ · Accepted solution]

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]

@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]

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

:

[himasreep445197]

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