Saving JCR query results | Community
Skip to main content
L
lrao
Level 2
October 16, 2015
Solved

Saving JCR query results

  • October 16, 2015
  • 3 replies
  • 6768 views

I ran a JCR query by going to CRXDE Lite and get the results I want. Is there a way to extract or save the result set from the query into  either text or excel file?

    Best answer by smacdonald2008

    Out of the box -- no; however - you can write a custom CQ service.  That is one of the most powerful features of AEM -- the ability to customize it. 

    We have community articles that will help you for this use case. 

    See this community article that will help you write an OSGi bundle that knows how to query the AEM JCR using the JCR API:

    http://scottsdigitalcommunity.blogspot.ca/2013/02/querying-adobe-experience-manager-data.html

    See this community article that talks about how to get Excel functionality into CQ:

    http://scottsdigitalcommunity.blogspot.ca/2013/08/creating-custom-excel-service-for-adobe.html

    Then you can combine the app logic shown in the 2 articles - that is - you can search the AEM JCR using the JCR API. Then you can write the result set to an excel Spreadsheet using the Excel API as discussed in the 2nd link. 

    Hope this helps

    3 replies

    J
    Adobe Employee
    JustinEd3Adobe Employee
    Adobe Employee
    October 16, 2015

    One option is to get the query results in JSON and then us jsawk (https://github.com/micha/jsawk) to transform the JSON result set into a CSV file.

      smacdonald2008
      smacdonald2008Accepted solution
      Level 10
      October 16, 2015

      Out of the box -- no; however - you can write a custom CQ service.  That is one of the most powerful features of AEM -- the ability to customize it. 

      We have community articles that will help you for this use case. 

      See this community article that will help you write an OSGi bundle that knows how to query the AEM JCR using the JCR API:

      http://scottsdigitalcommunity.blogspot.ca/2013/02/querying-adobe-experience-manager-data.html

      See this community article that talks about how to get Excel functionality into CQ:

      http://scottsdigitalcommunity.blogspot.ca/2013/08/creating-custom-excel-service-for-adobe.html

      Then you can combine the app logic shown in the 2 articles - that is - you can search the AEM JCR using the JCR API. Then you can write the result set to an excel Spreadsheet using the Excel API as discussed in the 2nd link. 

      Hope this helps

        jkpanera
        jkpanera
        Level 4
        May 4, 2020
        This is an acceptable answer for an open source project, but it really isn't an acceptable answer for "enterprise" software
          M
          michaelt7736928
          February 8, 2017

          My team had the same issue. You can also use a Chrome Plugin such as the one below and clean up the data in excel.

           

          https://chrome.google.com/webstore/detail/data-scraper/nndknepjnldbdbepjfgmncbggmopgden/related?hl=en-US

          Terms & ConditionsAccessibility statement

          Loading footer...