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

Saving JCR query results

Avatar

Avatar
Validate 1
Level 1
lrao
Level 1

Likes

2 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
lrao
Level 1

Likes

2 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
lrao
Level 1

15-10-2015

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?

View Entire Topic

Avatar

Avatar
Validate 25
Level 10
smacdonald2008
Level 10

Likes

1,406 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,406 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

15-10-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