This discussion is archived
1 Reply Latest reply: Apr 30, 2013 6:30 PM by scott.wesley RSS

Subscribing to Emailed Reports with filters

906336 Newbie
Currently Being Moderated
We have an application that have various levels of security such as "isadministrator" and "isuser". These filters are used to limit the interactive report data displayed. This security is based on the user logged into the system. When using the interactive tools all work fine including sending email reports. Unfortunately the Subscription always sends empty reports, this i suspect is due to the fact that there is no user logged in to run the report (the scheduler is running the report) so no authority exists and filters out all data.

eg.
select *
from employees
where lower(manager_id) = lower(:APP_USER)

Is there any way to pass the full (resolved) SQL to the scheduler?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points