Home » Developer & Programmer » Forms » please help
please help [message #385760] Tue, 10 February 2009 23:29 Go to next message
charuamit
Messages: 121
Registered: January 2009
Senior Member
Hi friends

I have a LOV with the query 'select dp_name from table'

as per the department selected, i m displaying the records for the selected departments.

Now i also want to include an elment 'ALL' in my LOV so as to display the records for all the departments.

How can i do that ?
please help me.

Thanks in advance.

Charu.
Re: please help [message #385771 is a reply to message #385760] Wed, 11 February 2009 00:08 Go to previous messageGo to next message
amit_yadav
Messages: 11
Registered: January 2009
Location: India
Junior Member
Dear Charu,

You can modify the query for your lov as:

SELECT 'All' dp_name FROM DUAL
UNION
SELECT dp_name FROM TABLE

You need to write a check in the code to display all records if 'All' is selected.

Thanks,
Amit
Re: please help [message #385781 is a reply to message #385771] Wed, 11 February 2009 00:47 Go to previous message
charuamit
Messages: 121
Registered: January 2009
Senior Member
Thanks.......
Smart suggestion Smile
I was trying all things with dynamically updating LOV,record group,List.....
But didnt try what u suggested.

Thanks A Lot.
Charu.
Previous Topic: Avoid error message if canvas doesn't exist
Next Topic: How to populate a different block after insert
Goto Forum:
  


Current Time: Sat Dec 10 18:41:59 CST 2016

Total time taken to generate the page: 0.10471 seconds