I created a value-set based on a field of a table.
I want to add (in the Where/Order By zone) the condition:
where current value's org_id equals the current responsibility's org_id
(so that only relevent values for the current responsibility would appear in the value set)
I tried the following code in the value set declaration:
(Where/order by) curr_column.org_id = :$Profiles$.org_id
This code returns error.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Reply With Quote
Bookmarks