Home » Developer & Programmer » Forms » 2 Lovs (Forms 6i)
2 Lovs [message #409298] Mon, 22 June 2009 01:21 Go to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

Can i put 2 search finds in one lov which has 2 items item code and name
Re: 2 Lovs [message #409304 is a reply to message #409298] Mon, 22 June 2009 01:43 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
I don't think so.
But why do you need it?

By
Vamsi
Re: 2 Lovs [message #409311 is a reply to message #409304] Mon, 22 June 2009 02:09 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

Just to make the search simpler.can we put a condition like radio button upon choosing we can search..
Re: 2 Lovs [message #409318 is a reply to message #409311] Mon, 22 June 2009 02:31 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Yes.
Depending on the radio button value, you can dynamically change the lov for that field.

By
Vamsi
Re: 2 Lovs [message #409319 is a reply to message #409318] Mon, 22 June 2009 02:38 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

yes but do you have any samples or u can send me some sample fmb having this functionality.
Re: 2 Lovs [message #409532 is a reply to message #409319] Tue, 23 June 2009 01:15 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Just use one record_group and two LOVs. One for each item.

David
Re: 2 Lovs [message #409534 is a reply to message #409532] Tue, 23 June 2009 01:22 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

thanks david but you misunderstood me , i want 2 finds (search criterias) in one lov.
Re: 2 Lovs [message #409548 is a reply to message #409534] Tue, 23 June 2009 01:36 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
How will the user determine which search criteria to use?

David
Re: 2 Lovs [message #409552 is a reply to message #409548] Tue, 23 June 2009 01:50 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

David its very simple i have two fields in lov item_code,item_name all i want is a "find" search on these two fields . i must have the facility to put item_code% or item_name% depending upon the radio button chosen or some other logic what you feel best.
Re: 2 Lovs [message #409557 is a reply to message #409552] Tue, 23 June 2009 02:02 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Then have a record_group based on item_code and item_name and depending on which item has the focus when the LOV is invoked change the sort sequence and display the LOV for that item.

David
Re: 2 Lovs [message #409559 is a reply to message #409552] Tue, 23 June 2009 02:03 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
I totally misunderstood the original post.
What I understood is:
You have two lov's and want to attach one of them to the item field depending on the radio button, which user has selected.

By
Vamsi
Re: 2 Lovs [message #409569 is a reply to message #409557] Tue, 23 June 2009 02:35 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

thanks david , but please give me any sample form with this idea.or if you can do that and give it to me as i am not that familiar to forms 6i.
Re: 2 Lovs [message #409751 is a reply to message #409559] Tue, 23 June 2009 19:53 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
@VamsiKrishna,

To have a different sort order based on a radio button do the following. Have two record_groups with the same 'select' but with a different sort sequence. In the 'show_lov' trigger of the item in question, use the value in the radio item to invoke a 'set_lov_property('lov_name', GROUP_NAME, 'rec_grp_name');' command which associates one or other of the record_groups to the LOV.

David
Previous Topic: Forms to call php file to output csv result
Next Topic: problem for export to excel functionality-unable to compile the form
Goto Forum:
  


Current Time: Sat Dec 03 07:47:11 CST 2016

Total time taken to generate the page: 0.08174 seconds