Count number of entries from a specific user

Count number of entries from a specific user

por Rory Bosch -
Número de respostas: 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


Media de puntuacións: -
En resposta a Rory Bosch

Re: Count number of entries from a specific user

por 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..
Media de puntuacións: -