Fixed value in Value set query — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Fixed value in Value set query

edited Jun 2, 2021 9:01AM in Reporting and Analytics for ERP 2 comments

Summary

Fixed value in Value set query

Content

we have defined the value set and validation type is Table

we have written condition to pick email ID from PER_EMAIL_ADDRESSES

As per condition, the result is giving all email IDs of employees but we have also a requirement to have one additional fixed value (dummy@****.com) which is not in PER_EMAIL_ADDRESSES table

How to bring fixed value and also value from a table in the single value set

 

 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!