on 2020 May 08 8:38 PM
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?
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
50 | |
9 | |
8 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.