Skip to main content
Solved

How to know environment on Quick Report

  • March 16, 2023
  • 1 reply
  • 89 views
C
Hero (Customer)
Forum|alt.badge.img+9

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 

Best answer by carlosfmendes

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%'

1 reply

C
Hero (Customer)
Forum|alt.badge.img+9
  • carlosfmendes
  • Author
  • Hero (Customer)
  • 31 replies
  • Answer
  • September 5, 2023

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%'


Terms & ConditionsCookie settingsAccessibility statement