Can you show your epifilter settings? And I’m assuming you went into the User Defined Code Maintenance and made a list. (had to check).
You can’t have double quotes. Try singles. (see example above)
1 Like
-.- Seems like the error message could have said that.
Now I get “Cannot find column CodeDesc.” I tried CodeTypeDesc as well, got the same message “Cannot find column CodeTypeDesc”
Ah, I changed EpiDataSetMode to RowsDataSet instead of ListDataSet and now it works.
1 Like
It’s RowsDataSet not ListDataset (That’s IMportant)
Also the Table Name should be UDCode and the BO is incorrect
4 Likes
How about we go back to the original question of how to Enable the EpiMagic for User Code Combos when running under MT SaaS license?
The User Code Combo EpiMagic is accomplished via the Extended Property “UDCodeType”. When the Combo is bound to a Column that has the Extended Property set, it will automatically fill in the Combos Properties for the User Code BO and the Code defined in the Extend Property.
Easiest way to set this up:
Customization Mode, Customization
From Tools Menu Select “Wizards”, “Customization Wizards”, “Modify Extended Properties” - Launch that wizard
Select the DataView and Field for the UD Column where you want to store the User Code
Select the “Format” Extended Property
for Value - Enter the User Defined Code Type value in this case: Profiles
Finish the Wizard.
On the Main Customization Dialog go to the Script Editor Tab and in the code find the line added to set the ExtendedProperties for “Format”.
Change the word Format to UDCodeType
Your code should look something like:
edvYourEpiView.dataView.Table.Columns["ShortChar01"].ExtendedProperties["UDCodeType"] = "Profiles";
Save Customization
Exit Form
Run Form - Select your customization. Now your Extended Property is “active”
Customize your form and add a Combo for your User Code.
When you bind it to the View and Column you defined in the Extended Property setup, the Combo will automatically configure as a User Codes Combo with “Profiles” as the Code Type.
8 Likes
Awesome!
There were so many of you that gave helpful replies - thank you guys. You are what make this forum great. With so many good responses I wasn’t sure which to mark as the solution, but I think @Rich solved the issue in a manner that was closest to what I was originally asking. So I have marked his as the solution.
Thanks everyone!
Yep, I think the limitation most of us have, many of us are on-prem and we assume that Epicor SaaS runs the same like on-prem. Which is false, because you guys have a tighter sandbox due to security.
And remember, all SaaS products are not the same. Only Multi-Tenant users have these kinds of restrictions. Single Tenant and Public Cloud (Dedicated Tenant) do not have those restrictions because we don’t share a database with other users like MT does.
Mark W.
1 Like
I would avoid using code for these unless the dataset isn’t available from a single table in a BO. EpiCombos are amazing for this. What @timshuwy states makes it even easier (unless you use SaaS, then it is a little more manual).
I’m trying to use this same trick to make certain columns required ex:
edvUD40View.dataView.Table.Columns["ShortChar03"].ExtendedProperties["Required"] = true;
But its not working. Does this trick only work for the UDCode property?
the best way to make a column required is in extended properties (the overall one) if you want it required everywhere.
1 Like
That entire window / module is off limits because of our licences (Cloud) - otherwise I would do that.
bummer…
The code pattern I provided works fine for Extended Properties that are applied to the Client. The “Required” property has mixed usage - on the UI it is used for the Visual “required” field indicator and on the Server it is used as part of the Business Rules validations.
For the MT SaaS environment access to the Extended Property maintenance is restricted as those properties are applied System Wide instead of being scoped to the Company / Tenancy. Best you can do for “Required” in MT SaaS is apply it in BPM.
2 Likes
Ok, thanks. Do you know if/when we get moved to the Azure public cloud will we be able to use the full set of Extended Properties?
You will need to verify with the SaaS team but my understanding is that the hosted DT customers do have access to the Extended Properties UI and associated functionality.
1 Like