cancel
Showing results for 
Search instead for 
Did you mean: 

Get the number of events created by Day

former_member182521
Active Contributor
0 Kudos
258

Is it possible to get the count 0f events created on daily basis from the Events table by their status?

Select * from Events - This just gives list. Is it possible to apply group by in the Query?

Accepted Solutions (0)

Answers (1)

Answers (1)

gmblom
Active Contributor
0 Kudos

Hello,

The SAP Java SQL layer does not support functions in a where clause, so it is hard to do a group by on date.

You can do the following per day:
select count(*) from Event e where e.CreationTime between now('truncate day') and now('truncate day subtract 1 day')

to get the amount of Events created for the full previous day.

Regards Gerben