This content has been marked as final. Show 4 replies
a multiselect radio button ? You mean users can select multiple values from your radio group item ? I cannot find this kind of item in apex.
Maybe you should use checkboxes.
If you are passing selected value using item substitution string :YOUR_ITEM, it should not be different from a select list or a textfield, in case a single value is returned. If you are getting several values (i.e. checkboxes), maybe you should take a look at APEX_UTIL.STRING_TO_TABLE and TABLE_TO_STRING functions.
Maybe you can share some code.
So depending on what you want to do with it, in PL/SQL you may have to use APEX_UTIL.STRING_TO_TABLE to get each values. Take a look at the documentation.
So in your function, you should have something like :
Maybe you can simply use INSTR function depending on your values :
DECLARE l_arr APEX_APPLICATION_GLOBAL.VC_ARR2; BEGIN l_arr := APEX_UTIL.STRING_TO_TABLE(:YOUR_ITEM); FOR i IN 1..l_arr.count LOOP // do something using l_arr(i) here END LOOP; END;
but be aware that it could give wrong results if you have values that may be contained in others.
SELECT * FROM YOUR_TABLE WHERE INSTR(:YOUR_ITEM,YOUR_VALUE) > 0
Example: INSTR('B:AC:BD','A') will return 3 but 'A' is not a valid value from your list.
please check below links
APEX_UTIL.PREPARE_URL does not work across workspaces?
hope this helps,
Migrate Database to ASM using RMAN
Set DISPLAY variable & Enable access control