Bulk Editor | Community
Skip to main content
anshikad
Level 2
Nov 18, 2015 10:51 AM UTC
Solved

Bulk Editor

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

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    anshikadAccepted solution
    Level 2
    Nov 19, 2015 10:57 AM UTC

    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??

    View reply

    6 replies

    james-mke
    james-mke
    Level 3
    Oct 5, 2020 4:41 PM UTC
    I tried using a similar query parameter as you defined above: "sling:resourceType":'commerce/components/product' but was unable to get any results with that simple evaluation. Has anyone created or used a similar query parameter to only evaluate if a file is a primary object within commerce?
    Translate
    kautuk_sahni
    kautuk_sahni
    Employee
    Oct 5, 2017 10:51 AM UTC

    Good read:- Coral UI based Bulk Editor

    ~kautuk

    Translate
    Kautuk Sahni
    anshikadAuthorAccepted solution
    Level 2
    Nov 19, 2015 10:57 AM UTC

    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??

    Translate
      anshikadAuthor
      Level 2
      Nov 19, 2015 10:54 AM UTC

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

      Translate
      Kunal_Gaba_
      Kunal_Gaba_
      New Participant
      Nov 19, 2015 7:44 AM UTC

      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. 

      Translate
      smacdonald2008
      smacdonald2008
      Level 10
      Nov 18, 2015 4:46 PM UTC

      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. 

      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...