Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Querybuiler is not giving correct result in publish instance

Avatar

Avatar
Ignite 5
Level 2
himasreep445197
Level 2

Likes

4 likes

Total Posts

12 posts

Correct Reply

0 solutions
Top badges earned
Ignite 5
Ignite 3
Ignite 1
Give Back 3
Give Back
View profile

Avatar
Ignite 5
Level 2
himasreep445197
Level 2

Likes

4 likes

Total Posts

12 posts

Correct Reply

0 solutions
Top badges earned
Ignite 5
Ignite 3
Ignite 1
Give Back 3
Give Back
View profile
himasreep445197
Level 2

29-12-2020

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.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 10
MVP
kunal23
MVP

Likes

166 likes

Total Posts

565 posts

Correct Reply

172 solutions
Top badges earned
Validate 10
Validate 1
Ignite 3
Ignite 1
Give Back 50
View profile

Avatar
Validate 10
MVP
kunal23
MVP

Likes

166 likes

Total Posts

565 posts

Correct Reply

172 solutions
Top badges earned
Validate 10
Validate 1
Ignite 3
Ignite 1
Give Back 50
View profile
kunal23
MVP

29-12-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.

Answers (2)

Answers (2)

Avatar

Avatar
Validate 25
Level 5
snbaem
Level 5

Likes

84 likes

Total Posts

206 posts

Correct Reply

26 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Contributor 2
Ignite 5
View profile

Avatar
Validate 25
Level 5
snbaem
Level 5

Likes

84 likes

Total Posts

206 posts

Correct Reply

26 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Contributor 2
Ignite 5
View profile
snbaem
Level 5

03-01-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

:

Avatar

Avatar
Validate 1
MVP
shelly-goel
MVP

Likes

158 likes

Total Posts

303 posts

Correct Reply

83 solutions
Top badges earned
Validate 1
Shape 1
Ignite 1
Give Back 5
Give Back 3
View profile

Avatar
Validate 1
MVP
shelly-goel
MVP

Likes

158 likes

Total Posts

303 posts

Correct Reply

83 solutions
Top badges earned
Validate 1
Shape 1
Ignite 1
Give Back 5
Give Back 3
View profile
shelly-goel
MVP

30-12-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.