| list of values [message #88183] |
Fri, 26 April 2002 11:31  |
Angie
Messages: 12
Registered: April 2002
|
Junior Member |
|
|
|
Is there a way to create a LOV where the user can select one item from the list or all items. I have created the list of items with the "ALL" selection but I don't know how to change my code to accomodate the user's selection of "ALL".
|
|
|
|
| Re: list of values [message #88187 is a reply to message #88183] |
Sun, 28 April 2002 20:49  |
Suraj
Messages: 38
Registered: April 2002
|
Member |
|
|
Hii Angie.
What u can do is , u can use the following query in the parameter query :-
select '%','All' from dual
union
select empno,ename from emp;
In the DataModel use the keyword ' like ' while using the above parameter.
Hope this solves ur problem
Bye..
SURAJ
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
