I'm trying to create a report of jobs that have closed within the last 60 days. It is a report that will get run on a monthly basis so the end date can't be a hard coded value.
Does anyone know how to get something similar to this:
select end_date, end_date - (to_number(substr(tz_offset( DBTIMEZONE ),2, 2))/24) as ActualTimeMinus from jtx.jtx_jobs where jtx.jox.jobs.end_date in (sys:cur_date - 60)
I have had success integrating more complex SQL queries (especially ones that need aggregate functions) into Workflow Manager by saving them as database views that are associated with the wmx schema. I am not very familiar with Oracle, but in SQL Server the view name ends up looking like wmx.VIEW_NAME. Once created, the view shows up just like a table in the Workflow Manager SQL editor for reports and queries. Maybe this can work for your SQL statement as well.
