Bulk Editor

Avatar

Avatar
Validate 1
Level 2
anshikad
Level 2

Likes

3 likes

Total Posts

4 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
anshikad
Level 2

Likes

3 likes

Total Posts

4 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile
anshikad
Level 2

18-11-2015

Hi,

While querying using the Bulk Editor i was able to run queries like:

"jcr:title":'GeoBlog'  "sling:resourceType":'social/blog/components/page' 

search for results with cq:tags, cq:toolbars, subtitles, etc but was not able to run queries for the following:

1. cq:template ("cq:template":'/libs/social/blog/templates/page')

2. cq:LastModifiedBy ("cq:LastModifiedBy":'admin')

3. jcr:createdBy ("jcr:createdBy":'admin')

Are there any special properties for these or any other requirements that i am missing on?

I'm using AEM6

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 2
anshikad
Level 2

Likes

3 likes

Total Posts

4 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
anshikad
Level 2

Likes

3 likes

Total Posts

4 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile
anshikad
Level 2

19-11-2015

The search is successful with the xPath query but there is no way to put LIKE in GQL while querying in the bulk editor. Is there any other way to do that??

Answers (4)

Answers (4)

Avatar

Avatar
Establish
Community Manager
kautuk_sahni
Community Manager

Likes

1,200 likes

Total Posts

6,394 posts

Correct reply

1,147 solutions
Top badges earned
Establish
Coach
Originator
Contributor 2
Contributor
View profile

Avatar
Establish
Community Manager
kautuk_sahni
Community Manager

Likes

1,200 likes

Total Posts

6,394 posts

Correct reply

1,147 solutions
Top badges earned
Establish
Coach
Originator
Contributor 2
Contributor
View profile
kautuk_sahni
Community Manager

05-10-2017

Good read:- Coral UI based Bulk Editor

~kautuk

Avatar

Avatar
Validate 1
Level 2
anshikad
Level 2

Likes

3 likes

Total Posts

4 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
anshikad
Level 2

Likes

3 likes

Total Posts

4 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile
anshikad
Level 2

19-11-2015

I have already gone through this documentation and the properties that I'm searching for are all having string values.

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

18-11-2015

Bulk editor uses JCR GQL API which internally translates the input query string to XPATH query and executes it as an XPATH query statement. I checked the converted statement for cq:template query and it was- 

/jcr:root/content/geometrixx-outdoors//*[(@jcr:primaryType='cq:PageContent' and jcr:contains(@cq:template, '/libs/social/blog/templates/page'))] order by @jcr:score descending

As you can see in the converted statement the GQL uses JCR contains function to search for the value of cq:template property. The contains function searches for values in the full text index. If the property is not indexed then it returns false. In AEM 6 cq:template property is not included in the full text index and thats why you do not get any results. The same logic applies for your other searches. If you replace jcr:contains with jcr:like then the query will return results in AEM 6 but not with contains function unless you include these properties in your full text index. 

Avatar

Avatar
Validate 25
Level 10
smacdonald2008
Level 10

Likes

1,409 likes

Total Posts

12,671 posts

Correct reply

2,278 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Give back 900
Give back 600
View profile

Avatar
Validate 25
Level 10
smacdonald2008
Level 10

Likes

1,409 likes

Total Posts

12,671 posts

Correct reply

2,278 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Give back 900
Give back 600
View profile
smacdonald2008
Level 10

18-11-2015

See this AEM doc topic - make sure that you specify your query parameters properly - as discussed here:

https://docs.adobe.com/docs/en/cq/5-6-1/administering/bulk_editor.html#Searching and Editing Content

Also - note in the docs - you can only search for string values.