OraFAQ Forum: Forms » Dynamic Lov

Home » Developer & Programmer » Forms » Dynamic Lov (forms 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Dynamic Lov [message #462575]

Fri, 25 June 2010 01:22

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

Hi,

I have text item and it is assigned with lov namely 'Typelov' and that xlov assigned with 'Rgtype'.

When I create the record group i just create with sql

like

select distinct type from x;

But at runtime i want to change the query

select distinct type from x where col1 = 'XXX';

and now the lov should display the above filtter condition item only.

Is there any possible

kanish

Report message to a moderator

Re: Dynamic Lov [message #462597 is a reply to message #462575]

Fri, 25 June 2010 04:15

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Create a second record group with the other query. Use set_lov_property to change which record_group the LOV is using.

Report message to a moderator

Re: Dynamic Lov [message #462691 is a reply to message #462597]

Fri, 25 June 2010 12:43

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Another option is to let users filter values selected from a LoV (before LoV is displayed). I don't have Forms installation here so I can't check it, but it is an option you'll (easily) find in the property palette.

Report message to a moderator

Re: Dynamic Lov [message #462700 is a reply to message #462575]

Fri, 25 June 2010 15:09

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Why don't you just have the record_group use your query with the condition?

select distinct type from x where col1 = nvl(:col_on_screen,col1);

and have col1 as a field on the screen that will affect what is displayed in the LOV.

Report message to a moderator

Previous Topic:	Dynamically setting no of records displayed in block
Next Topic:	Report Print

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 03:53:53 CDT 2024