Expand my Community achievements bar.

SOLVED

Querybuiler is not giving correct result in publish instance

Avatar

Level 2

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.

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

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.

View solution in original post

4 Replies

Avatar

Correct answer by
Employee Advisor

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.

Avatar

Employee Advisor

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

Avatar

Community Advisor

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

:

Avatar

Level 2

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