Request Type SQL rule to populate a multiselect field

ScottW1 5 months ago

I'm trying to create a Field Change Rule to automatically add 3 values to a multiselect field based on the update of a simple single select field and I can't seem to get the SQL right. I've tried the following two approaches, but both are invalid. I'd prefer not to create a function. Any suggestions.

Option 1:
select
'code1', 'value 1',
'code2', 'value 2',
'code3', 'value 3'
from dual

Option 2;

select
'code1#@#code2#@#code3'
'value 1#@#value 2#@#value 3'
from dual

Thanks,

Top Replies

Suggested Answer

0 Etienne Canaud 5 months ago
Hi Scott,

Oracle's DUAL special table has only one row, so if you want to retrieve multiple records, you can use UNION:

select 'code1', 'value 1' from dual UNION ALL select 'code2', 'value 2' from dual UNION ALL select 'code3', 'value 3' from dual
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel
Verified Answer

+1 ScottW1 5 months ago in reply to Etienne Canaud

Thanks for the info. I realized this morning that option 2 would have worked but I forgot a comma. Once corrected, it worked fine.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Reject Answer

Cancel

Menu

PPM User Discussions

Verified Answers

Request Type SQL rule to populate a multiselect field

Top Replies

Suggested Answer

Verified Answer

Resources