How to extract List of authors in AEM using XTYPE query

[ranadyutis95334]

We need the list of users who are author. we are trying below query :

/jcr:root/home/users/*//element(*,rep:User).

but this is giving error. Please help.

[leeasling · Accepted solution]

Try this:

/jcr:root/home/users//element(*, rep:User)

Also, the query debug tool is a great way of playing with queries: http://localhost:4502/libs/cq/search/content/querydebug.html

[ranadyutis95334]

Thanks a lot. Is there a way to extract this data in csv or text file

[leeasling]

Not out of the box.  You'd need to write some code to do that for you.