Add GetUserCodeDesc as Helper Function in SQL for BAQ Designer

Epicor comes with some Functions which you can use in the BAQ Designer.

2019-02-15_1224

I would suggest to add a function GetUserCodeDesc(CodeTypeID, CodeID) which would allow us to create Calculated Fields and just keep the BAQ Clean instead of doing:


Currently: CTE.

Even doing 1 Sub-Query, you can’t re-use it as a SUB-Select. Perhaps a Pivot, with tweaks. Sure this would still be a Sub-Query, but it would be easy to use… a Function in a Calculated Field.

Good or Bad Suggestion idk @Dmitry_Kashulin