RWB Execution History

Description

Categories
RWB
Execution history of Polaris Reporting Workbench reports. This can be used when migrating from Polaris Reporting Workbench to Blitz Report, to analyze which Polaris reports were previously used by the business.

SQL 59 lines

Parameters 7

ParameterTypeList of values SQL
Report NameLOV
upper(rr.report_name) like upper(:report_name)
Submitted by UserLOV
rrs.user_id=xxen_util.user_id(:created_by)
Started within DaysNumber
rrs.start_time>sysdate-:days
Start Date FromDateTime
rrs.start_time>=:start_date_from
Start Date ToDateTime
rrs.start_time<=:start_date_to
Run TypeLOV
rrs.run_type=:run_type
Exclude output generationLOV
rrs.report_id>0