I am attempting to complete the Epicor ERP Configurator Course10.2.500. We are a cloud client, so we are stuck using the Expression Builder. How do I find the Switch, Case, and Break functions within Expression Builder? The embedded education is intended to be completed in the Education Database, but I am struggling trying to build the expression shown in the course document using the Expression Builder.
You will find the expression editor so incredibly enraging that you will learn to avoid it at all costs. Talk about bad UX.
Do all your logic inside the configurator, and then set the results to inputs you can use in the rules. In this case, have the switch statement in a UD method and then have the return value stored in an input that you can use in the rules. This will minimize the amount of time you have to use that god awful tool.
4 Likes
Oh, and as far as I can tell you can’t enter a switch statement. The person who wrote that lesson probably had the ability to type whatever they wanted unlike us. I’d report the issue.
Switch would most likely be under the Condition group in the left pane.
But like @Evan_Purdy said, you’ll be much happier just typing the code in.
edit
just re-read that you said being on the cloud prevent from direct code entry. That correct?
and FWIW - most switch/case expressions could be done as nested If-then-Else
if(Inputs.P01_CmbFrameSize.Value == "3x5"){
return 16;
}
else if(Inputs.P01_CmbFrameSize.Value == "5x7"){
return 24;
}
else{
return 36;
}
Yes, that is one of the many reasons its so awful. If you want to change something at the start you have to delete all of your work and start over…
So upon clicking the Edit button on the Config UD Methods Maint window, it launches the expression builder, and not the following?
- Configurator Rule expressions use the expression builder
- Server side UD methods use the expression builder and have most functions removed.
- Client side UD methods can use the free form editor you have pictured, but no references can be added.
To finish your education task, just make use the expression builder to make 2 If then statements. don’t need the “else” because on each successful “If” the function exits when it hits the return statement.
will work
EDIT
Whoops! had the wrong screen shot pated
1 Like
Yeah, the Education Database is built on MT promises. 
If you had an Education database built in Azure in a dedicated environment, you don’t have these restrictions. It’s not a cloud restriction as much as it is this Multi-Tenant idea that has long out-lived its usefulness.
Thank you all for your contributions. If Epicor knows this limitation, why don’t they update the course manual to use the formula Calvin suggested?
Because the squeaky wheel gets the grease. Complain about it to them and they may fix it, otherwise they have bigger fish to fry.
Just wait until you have cases accepted as a problem and then rejected by development as will not fix 
Hi Brian,
We created a Cloud version of the Configurator course - are you using that?
Wait! What?
It’s been there for awhile - it’s called Epicor Cloud ERP Configurator Course. Let me know if that helps!
What is Epicor’s rationale for only allowing Expression Builder?
For security, to keep tenants form possibly accessing other tenants data?
Or for performance, so that one tenant does use poorly written code, which could cause issues for other tenants?
Staci,
Thank you for pointing out the Epicor Cloud ERP Configurator course. It is further down in the list of Sales Management courses, so it did not jump out at me.
Is there an Advanced Configurator course that is geared towards Cloud customers? I am planning on taking the Advanced Configurator course next.
It probably would have been helpful if it was named Configurator (for Cloud ERP) and placed directly below Configurator.