How to know environment on Quick Report

Question

Hi everyone,

I have created a few quick reports, that we then send through application server tasks and background jobs on a regular basis.
When our department leader decides to ask an IFS partner to copy from PROD environment to TEST environment and we are not informed, we receive these quick reports in double, from PROD and TEST, however the problem is we don’t know which one is from PROD and which one is from TEST.

Is there any possibility to put the environment on the email subject to differentiate the quick reports?

Thanks in advance,

Carlos Mendes

Page 1 / 1

To solve this issue, I simply added to the quick report queries the following code, so if it is not PROD, it simply gives 0 lines back.

AND UPPER((SELECT Sys_Context('UserEnv', 'Db_Name') AS Instance FROM Dual)) LIKE '%PROD%'

Reply

carlosfmendes · Accepted Answer

To solve this issue, I simply added to the quick report queries the following code, so if it is not PROD, it simply gives 0 lines back.

AND UPPER((SELECT Sys_Context('UserEnv', 'Db_Name') AS Instance FROM Dual)) LIKE '%PROD%'

Reply

Did you find what you're looking for? If not:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded