User Codes in Selection Lists

So i have a list of selections i would like to use a Selection List and the list is from a UD codes.

I have created rest event to get the data and populate the data view in the screen. The event is based on after the get by ID.

I can see the rest call get called successfully and the data view get populated and i can see the data in developer tools.

When i preview the application my selection does not have any of my selections from the new dataview.

Can anyone provide me some support on this.

How To: Kinetic Selectable List - Experts’ Corner - Epicor User Help Forum

Kinetic Control Compendium - Experts’ Corner - Epicor User Help Forum

2 Likes

Followed both articles you have linked sorry on missing some information on the post here is more details.

DataViews
image

Configuration on the Selection List


image
image

Here is the Rest Event


image
image

Here is the data return from the rest call

It’s been a hot minute since I’ve played with those. I’ll see if I can find some time to take a look again.

this is an error i am seeing in the debugger

not sure if this help or not.

I’ve been fighting populating selection lists with User Codes all last week. I ended up creating BAQs to select the User Codes I want, creating empty Data Views and populating them with a chain of BAQ calls using the kinetic-baq widget attached to the BeforeInitialize event.

I think something is broken in App Studio, because as soon as you add a 2nd reusable combo for User Codes with a different CodeTypeID, Kinetic blows up. I was getting the data from my 2nd User Codes call overwriting the data in the data view for the 1st. BAQs solved it.

Okay, I had to fight with this a bit.
The biggest takeaway is make sure everything is initialized before the control is painted. So, load data into all of your views (source and target) on load otherwise it gets cranky.

Also, take out the Target Desc Col field.

Here’s my setup which takes the list from a BAQ view and puts it into a TransView variable.

1 Like

I should also point out that when you make selections and you have it set up to be a view, it’s going to save it to that view vs what you have in the epBinding.

2 Likes

Actually, you can do this too which lets you put the Target Desc Col in. This control is dumb.

** You can move the Source View Name to the Source Table Name too, I guess.
Also, if you’re populating data from the same table, you can omit the Source/Target Tables and just populate “Table Name.”

1 Like

I made these notes for using UD codes in a combo:

-UserCode Combo (NOTE: This method returns the CodeID field not CodeDesc):
Kinetic Combo Box Binding UDCodes Blank - #3 by josecgomez
Kinetic Combo Box Binding UDCodes Blank - #6 by josecgomez
and Kinetic Combo Box Binding UDCodes Blank - #15 by Dhanalakshmi

  Data > EpBinding = View.Column 
  Reusable Combo > Type = UserCodes.UserCodesCombo
  Reusable Combo > Sub Type = default
  Reusable Combo > Filters Params	= "CodeTypeParam=CodeTypeID" (no quotes)
  
  -To filter out inactive records: 
  	Reusable Combo > Hidden Columns Append: IsActive
  	Advanced >  Row Filter: "IsActive = true" (no quotes) 

  -To Return CodeDesc instead: 
  	Reusable Combo > 
  		Type: leave blank 
  		Sub Type: leave blank 
  		ComboID: leave blank 
  		Service: Ice.BO.UserCodessvc
  		Service Method: GetRows
  		Table Name: UDCodes
  		Sort: CodeID 
  		Retrieve Columns: CodeDesc		
  		
  	Advanced >
  		Drop Down Style: DropDown 
  		TextField: CodeDesc
  		Value Field: CodeDesc
  		Search Filter: CodeTypeID = 'CodeTypeID'
6 Likes