| Display report based on the value picked from select list [message #581624] |
Tue, 09 April 2013 07:48  |
 |
inka
Messages: 14
Registered: February 2013
|
Junior Member |
|
|
Hello All,
I am using Apex 4.1 and Oracle 11g. I have a form with four fields on it. One of the fields is the select list. I woud like to add the report to this form but only display the values based on the value selected from the select list. How would I do that?
|
|
|
|
| Re: Display report based on the value picked from select list [message #581706 is a reply to message #581624] |
Wed, 10 April 2013 01:20  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
If you put (i.e. display) selected items in a text item, you'll see that these values are separated by a colon sign. For example, if return LoV values of the select list item are 1, 2, 3, 4, 5 and you select 1, 3, and 4, the result looks like this: 1:3:4.
It means that you'll have to pass that string to a report and then, in report's query, split that column into rows. For example:SQL> with test as
2 (select '1:3:4' col from dual)
3 select regexp_substr (col, '[^:]+', 1, level) result
4 from test
5 connect by regexp_substr (col, '[^:]+', 1, level) is not null;
RESUL
-----
1
3
4
SQL>
Which, finally, means that report's query would look like
select col1, col2, ...
from some_table
where id in (select regexp_substr (:P1_SELECTED_ITEMS, '[^:]+', 1, level) result
from dual
connect by regexp_substr (:P1_SELECTED_ITEMS, '[^:]+', 1, level) is not null
)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
