StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » Browser Dialog: Fill combobox based on parameter of another combo

Browser Dialog: Fill combobox based on parameter of another combo

Edhy Rijo — Fri, 22 Oct 2010 13:10:09 GMT

Hi,

I have two combobox in a Browser Dialog "Customers" and "Building Address". The records in the Building Address should be filtered by the selected Customer.

I have done this for the maintenance form, but I have not find a way to have the combo filtered in the Browser Dialog (BD), and the events exposed to the BD does not allow me setup code to Requery the BuildingAddress BO.

RE: Browser Dialog: Fill combobox based on parameter of another combo

Ivan George Borges — Fri, 22 Oct 2010 13:10:09 GMT

You're welcome. :cool:

RE: Browser Dialog: Fill combobox based on parameter of another combo

Jéssica Neves — Fri, 22 Oct 2010 13:04:41 GMT

thank.

Ivan!!!

RE: Browser Dialog: Fill combobox based on parameter of another combo

Ivan George Borges — Fri, 22 Oct 2010 11:33:53 GMT

Hi Jéssica.

You will basicaly use the Search Field "Combo - Business Object" tab and set the Combo Population.

On the Search Fields dialog, Edit the search field and set it to your foreign key:

Then, under Combo - Business Object, configure the List Population Settings to use the BO you want and its Fill Method to bring the rows you want the combobox populated with:

Also, have a look at the help file under : "Application Framework" / "UI Layer" / "Controls" / "Browse Dialog" / "Working with the Browse Dialog" / "Setting the Search Fields".

RE: Browser Dialog: Fill combobox based on parameter of another combo

Jéssica Neves — Fri, 22 Oct 2010 11:05:14 GMT

Hello!
I have a table of documents.
Documento_ID
this table have a foreign key to the table people.
Documento_Pessoas_ID
so I'm using a browser dialog ..
how do I bring the name of the person that is in the document
I would have to use the property search fields, Comb - business object?

have any examples to show me?

RE: Browser Dialog: Fill combobox based on parameter of another combo

Edhy Rijo — Wed, 24 Sep 2008 21:27:45 GMT

[quote][b]Trent L. Taylor (09/24/2008)[/b][hr]... and I am answering forum posts from my wife's laptop)[/quote]

That is a great excuse. :P Just kidding :hehe:

I will try to setup a sample test with the SF sample database, there is not rush on this one, so it can wait.

[quote]As for the SearchValueChanged, this is correct and where you will want to place your code...it has actually been here since 1.6.5 I am pretty sure.[/quote]

Thanks for the confirmation, I got confused trying to get the values, but it is working beautifully and a very powerful functionality.

RE: Browser Dialog: Fill combobox based on parameter of another combo

Trent L. Taylor — Wed, 24 Sep 2008 21:20:26 GMT

Honestly without setting this up I can't give you a straight answer off of the top of my head in regards to the sizing. The sizing of the controls is done when they are created , but they anchors are also set. You this could be what you are fighting. But without setting up a quick sample I don't remember (and I am answering forum posts from my wife's laptop). I will try and look at this over the weekend or something.

As for the SearchValueChanged, this is correct and where you will want to place your code...it has actualy been here since 1.6.5 I am pretty sure.

RE: Browser Dialog: Fill combobox based on parameter of another combo

Edhy Rijo — Wed, 24 Sep 2008 16:08:14 GMT

Hi Trent,

I think I figured out by using the SearchValueChanged event. Could you please check this out to see if it is correct?

[quote][code]

Private Sub ServiceCallsBrowserDialog_SearchValueChanged(ByVal sender As System.Object, ByVal e As MicroFour.StrataFrame.UI.Windows.Forms.BrowseDialogSearchValueChangedEventArgs) Handles MyBase.SearchValueChanged

'-- When a customer is selected form the combobox, then requery the Building combobox.

If e.SourceSearchField.Key.Equals("FK_Customers", StringComparison.OrdinalIgnoreCase) Then

Dim comboListPopulationParam1 As Integer = 0

'-- If the customer combobox has any selected record, then update the

' comboListPopulationParam1 with the Customer PK

If CType(e.SourceControl, ComboBox).SelectedIndex > 0 Then

'-- Resize the combo to properly show its information.

e.AllVisibleSearchControls("FK_Buildings").Width = 300

comboListPopulationParam1 = CType(e.SourceControl, ComboBox).SelectedValue

End If

'-- Requery the Building Address combobox.

CType(e.AllVisibleSearchControls.Item("FK_Buildings"), ComboBox).Requery(comboListPopulationParam1, MicroFour.StrataFrame.Business.BusinessEditingState.Idle)

End If

End Sub

[/code][/quote]

Also, the Building Address ("FK_Buildings") field combobox is not sized properly, the field type is an Integer, but the size of the combo is not enough to show the data correctly, so I am using e.AllVisibleSearchControls("FK_Buildings").Width = 300 here to at least re-size the combo when the Customer record has been selected, but that is not the correct way. Is there a way to set the size of any control in the Browser Dialog programmatically?

RE: Browser Dialog: Fill combobox based on parameter of another combo

Edhy Rijo — Wed, 24 Sep 2008 14:54:14 GMT

Hi Trent,

I though this functionality was added to the framework at some point, if so, how would I get access the value of a search field in the browser dialog?

RE: Browser Dialog: Fill combobox based on parameter of another combo

Trent L. Taylor — Mon, 22 Oct 2007 09:18:23 GMT

Yeah, I will add it to our future enhancement list to look at. Thanks :)

RE: Browser Dialog: Fill combobox based on parameter of another combo

Edhy Rijo — Fri, 19 Oct 2007 10:36:40 GMT

[quote][b]Trent L. Taylor (10/19/2007)[/b][hr]This is probably a good enhancement request. Sorry :ermm:[/quote]

Hi Trent,

Thanks for the response, even thought it is really sad for me. Do I have to enter this in the enhancement request forum, or you will take care of it for me? :P

I do like the way you guys design the Browser Dialog, but more hooks and flexibility are needed in there in order to allow the developer to cover more custom request by the application. So more events and access to the controls PEMs in the browser will enable this flexibility for us.

I would like to be able to do something like this:

[codesnippet]

Me.ServiceCallsBO1_BrowseDialog.SearchFields("FK_Customers").Value

Me.ServiceCallsBO1_BrowseDialog.SearchFields("FK_Customers").Requery()

[/codesnippet]

RE: Browser Dialog: Fill combobox based on parameter of another combo

Trent L. Taylor — Fri, 19 Oct 2007 09:09:47 GMT

At present, not easily. There is not a way for you to implicitly requery another combo within the browse. This is probably a good enhancement request. Sorry :ermm:

RE: Browser Dialog: Fill combobox based on parameter of another combo

Edhy Rijo — Wed, 17 Oct 2007 11:05:17 GMT

Hi Ben, Trent,

Could you please tell me if this is possible to do?

Thanks!