How to: determine all tasks within workflows where a earliest starttime is defined

Discussion created by Harald_Heidinger_152 on Dec 6, 2017
Latest reply on Dec 7, 2017 by Pete Wirfs
Since this cannot be listed now even with the advanced search, i have created a sql statement which lists all objects within workflows which contain an earliest starttime.

select OH_Idnr, OH_Name, JPP_Object, JPP_ErlstStTime from JPP 
inner join OH on OH_Idnr = JPP_OH_Idnr 
where JPP_ErlstStTime is not NULL 
and JPP_Object = 'START' 
and OH_Client = 'xx' >>>>> there place clientnumber

you can add this e.g. to a SQLI Vara and click "Preview" to get a list of results, if you dont want to log in to a SQL Developer or Oracle Console.