Add GetUserCodeDesc as Helper Function in SQL for BAQ Designer

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


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