How to count the number of articles per user

[Dilpreet Sohanpal]

Hello All,

I have a requirement to count the number of articles CREATED by each user along with the date of article creation.

Please could some let me know how this can be done. I have default Database which comes with Confluenece.

Thanks

Dilpreet

[PeterKoczan]

Hi,

In MySQL you could use something like this:

select creator,date_format(CREATIONDATE,'%Y-%m-%d'),count(*) from CONTENT where prevver is null and creator is not null group by creator,date_format(CREATIONDATE,'%Y-%m-%d') order by creator,date_format(CREATIONDATE,'%Y-%m-%d')

Cheers,

Peter