AnsweredAssumed Answered

How to find all Time Event objects with period less than 15 min

Question asked by Krum_Ganev on Feb 27, 2018
Latest reply on Feb 27, 2018 by Krum_Ganev
Hello All,

We agreed with customer to set a minimum time period for all Time Events to 15 minutes.
We have more than 4300 EVNT objects.

Would you please help me how to build SQL query to find all Time Events with interval less than 15 minutes.

We've tried this but it doesnt show the needed information


select oh_name,OEA_TimePeriod from oh,oea where OH_OType = 'EVNT' and OEA_EventType = 'TT' and OEA_TimePeriod < 0015 and OH_DeleteFlag = 0 and oh_client = 100