| OAF Field Ref in ValueSet Table Where Clause [message #662258] |
Fri, 21 April 2017 12:45 |
 |
OraFus_J
Messages: 1
Registered: April 2017
|
Junior Member |
|
|
I am trying to reference a field on an html page in order to limit my ValueSet Lookup. Is it possible to do this? I have been able to locate the Fusion tables and columns in order to lock down what I need to the column and table but the list shows values for all records in the table.
I really want to just have the ValueSet look at the current row/record that is up in the html page.
Is this possible?
Below is the current setup in my ValueSet:
FROM Clause: PJF_PROJECTS_ALL_B Pro, POR_REQ_DISTRIBUTIONS_ALL Req, POR_REQUISITION_LINES_ALL LIN
Value Column Name: Pro.Attribute10
Description Column Name: to_char(LIN.LINE_NUMBER)
ID Column Name:
WHERE Clause: Req.REQUISITION_LINE_ID = LIN.REQUISITION_LINE_ID AND Req.PJC_PROJECT_ID = Pro.Project_ID
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
