Version: 10.5 SP1
Servers Type: PROD
Database: Oracle
Initially, we created a report to find the permissions changes that an user has executed between specific dates. The initial report didn't have the gather the user's inputs. The script and a piece of the initial report without the user input is below.
select p.auditid, p.auditstr, p.auditdate, p.dataid, m.name, p.subtype, p.valuekey, p.value1, p.value2
from dauditnew p
INNER JOIN Dtree m ON m.dataid = p.dataid
where p.auditdate >= to_date('2018-08-02 23:59:00', 'YYYY-MM-DD HH24:MI:SS')
and p.auditdate <= to_date('2018-08-03 23:59:00', 'YYYY-MM-DD HH24:MI:SS')
and p.auditstr = 'PermChange'
and p.PERFORMERID = 404115
and (p.dataid = 609925)
order by p.AUDITDATE
As second step, we wanted to gather the user input instead of coding the information in the script. We only get a blank page result. Can somebody look at it? The script of the version with the user inputs iis below, along with the Inputs & Parameters we choose.
select p.auditid, p.auditstr, p.auditdate, p.dataid, m.name, p.subtype, p.valuekey, p.value1, p.value2
from dauditnew p
INNER JOIN Dtree m ON m.dataid = p.dataid
where p.auditdate >= %1
and p.auditdate <= %2
and p.auditstr = 'PermChange'
and p.PERFORMERID = %3
and (p.dataid = %4)
order by p.AUDITDATE
Parameters
We need help to complete this report.
Thank you in advance,
Marcelino
