Count number of entries from a specific user

Count number of entries from a specific user

by Rory Bosch -
Number of replies: 1

Hi, I'm new to dataform.

Is it possible to count and display the number of entries from a specific user?

For example: 

user 1 : 5 entries

user 2 : 7 entries

user 3 : 0 entries


greetings,

Rory


Average of ratings: -
In reply to Rory Bosch

Re: Count number of entries from a specific user

by Ambrish Tiwari -

Hi Rory

You should be able to do a Aggregate query to obtain this.  If you want to get the number of votes a specific user has given:
 
select count(ParentId)
from Vote
where CreatedById = 'xxxxxxx'
     Parent.Type = 'yyyyyyyy'


where 'xxxxxx' is the user's id..
Average of ratings: -