Cannot populate an EpiUltraCombo with list of values from UDCode

Yahoo Archive
1
CallContextBPMData doesn't appear in the list of tables available in Extended Properties maintenance.

The combo-box EpiBinding is to CallContextBpmData.Character10. This is precisely what I need, but I could always assign that using script.

If there is a BO where a "GetList" returns UDCodes (child) instead of UDCodeType (header) I would be all set. Can you load a combo box with the results of a user-defined query? That would be easy enough to write.

Should I "fake it out" by using a field in one of the real tables, e.g. PartAlloc? But the entry applies to the entire search, not any particular record. If you call up Fulfillment Workbench and go to Order Fulfillment tab you 'll see what I mean. I'm adding the combo-box to the filtering, not to a particular table or column.

Here are the possible EpiBinding choices (pasted, might not come through):

[cid:image001.png@01CCF6D7.F4F39F30]


________________________________
NOT INTENDED AS A SUBSTITUTE FOR A WRITING
NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER.

This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.


[Non-text portions of this message have been removed]
2
I have added a ComboBox to the Fulfillment workbench where I want to let the user select a release fulfillment type (a PNY concept) of which there are three.

I created a UDCodeType "RelType".

I added 4 child records for ALL, DC, PTL, OTHER.

I started fulfillment workbench and went into customization of the base form.

I added an EpiUltraCombo to the Order Tab fulfilment search sheet, to the right of Line count and release count <= Fill-ins.

In Customization Tools Dialog i did Tools > Wizards > Customization Wizards ... Simple Search (launch) (Get Adapters ...) selected UserCodesAdapter.

Custom DropDown ... I selected my EpiUltraComboC1.

Value Field and Display Field. HERE IS THE PROBLEM! It is ONLY showing the fields available in UDCodeType (header) table. So I cannot select UDCodes.CodeID which is the field that has my values. I really don't care about the description -- CodeID could fill both value and description. BUT IT IS NOT PRESENTED AS AN OPTION!

Is there a different Adapter which has the UDCodes table? I looked carefully several times and I don't see any alternative.

I notice using the ICE BL Tester that "GetList" returns a list of UDCodeType records. Then GetByID given CodeTypeID = "Reltype" returns the Header/Detail Dataset with the UDCodes detail records.

Note that I am binding the combo-box to CallContextBPMData and thus I am not able to set the extended properties of the bound field (Character10). I found those entries but they will not work here. If I enter the value manually it IS travelling down the the appserver via CallContextBPMData and I'm able to use it to filter the GetListOrders exactly the way I need.

The values I am setting will probably never change. So if there is a way to do this with a static EpiCombo, that is a reasonable workaround.
3
can't you bind the user codes using extended properties maintenance? or am
I missing something?

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Tue, Feb 28, 2012 at 5:57 PM, reptcon <cheins@...> wrote:

> **
>
>
> I have added a ComboBox to the Fulfillment workbench where I want to let
> the user select a release fulfillment type (a PNY concept) of which there
> are three.
>
> I created a UDCodeType "RelType".
>
> I added 4 child records for ALL, DC, PTL, OTHER.
>
> I started fulfillment workbench and went into customization of the base
> form.
>
> I added an EpiUltraCombo to the Order Tab fulfilment search sheet, to the
> right of Line count and release count <= Fill-ins.
>
> In Customization Tools Dialog i did Tools > Wizards > Customization
> Wizards ... Simple Search (launch) (Get Adapters ...) selected
> UserCodesAdapter.
>
> Custom DropDown ... I selected my EpiUltraComboC1.
>
> Value Field and Display Field. HERE IS THE PROBLEM! It is ONLY showing the
> fields available in UDCodeType (header) table. So I cannot select
> UDCodes.CodeID which is the field that has my values. I really don't care
> about the description -- CodeID could fill both value and description. BUT
> IT IS NOT PRESENTED AS AN OPTION!
>
> Is there a different Adapter which has the UDCodes table? I looked
> carefully several times and I don't see any alternative.
>
> I notice using the ICE BL Tester that "GetList" returns a list of
> UDCodeType records. Then GetByID given CodeTypeID = "Reltype" returns the
> Header/Detail Dataset with the UDCodes detail records.
>
> Note that I am binding the combo-box to CallContextBPMData and thus I am
> not able to set the extended properties of the bound field (Character10). I
> found those entries but they will not work here. If I enter the value
> manually it IS travelling down the the appserver via CallContextBPMData and
> I'm able to use it to filter the GetListOrders exactly the way I need.
>
> The values I am setting will probably never change. So if there is a way
> to do this with a static EpiCombo, that is a reasonable workaround.
>
>
>


[Non-text portions of this message have been removed]