@User_G1EP3 - If you are looking to find the parameters configured in a dataset within a BIP report, please refer to the documentation below for the navigation path:
https://docs.oracle.com/middleware/12213/bip/BIPRD/GUID-2EE979EC-D88B-4B70-B15B-AF887B499BD6.htm#BIPRD-GUID-F5F8BC93-8FD5-40E6-81EA-E640012123A9
I have a requirement to pass multiple values of paramter in dataset. The values are from fixed data LOV like 0-30,6-21,0-5 etc. I have no option to use IN clause. so I am using REGEX to split it into multiple values.
Ex: If user selects 0-30,6-21, I want to split that into 2 rows (first row 0-30 and second row 6-21).
Below code is working for hardcoded values.
SELECT TRIM(REGEXP_SUBSTR('[0-30,6-21]', '[^,]+', 1, LEVEL)) AS value FROM dual CONNECT BY REGEXP_SUBSTR('[0-30,6-21]', '[^,]+', 1, LEVEL) IS NOT NULL
But it is not working for parameter. I used below query in dataset.
SELECT TRIM(REGEXP_SUBSTR(:P_buckets, '[^,]+', 1, LEVEL)) AS value FROM dual CONNECT BY REGEXP_SUBSTR(:P_BUCKETS, '[^,]+', 1, LEVEL) IS NOT NULL
So I would like to know how the values will be passed to dataset in case of multiple selection.
Multiselect parameters pass a comma separated list of values wrapped in parenthesis and square brackets.
Ex: ([value1, value2, value3]).
Rgds,
Kevin
I kept the logic based on ([value1, value2, value3]) only. But it is not passing it.
Please try below query. P_BUCKET displaying NULL
select :P_BUCKETS from dual
Test the LOV SQL as a dataset.
What does it return?
I am using fixed data lov as shown below
