Fields (10) - In the tree view, you can select any of the current Display Fields and existing Calculated fields you want to add to the calculation. You can also pull in any fields contained within the Available tables included with the current query. If you have created Parameters and Scalar Functions to use with the BAQ, these options are available for selection as well.
Mising Scalar Functions in Calculate Field SQL Editor in my Epcior Instance 2023.2.25
I am going to guess that it’s been removed. I’m assuming that the idea was to give you the ability to add scalar functions to your database or use ones that already exist like GetCustid which allows you to pass in the company and custnum and return the custID, rather than doing a join on the customer table all the time.
So unless there is some epimagic way to get access to these (and I don’t see that would happen in cloud) then I think it’ going away.
Of course I could be terribly wrong and happy to be schooled otherwise @Banderson perhaps you could enlighten us?
I just learned something new! Honestly I never even knew that those were there, or relied much on scalar functions. The only one I ever used was Ice.Entry() because there isn’t an easy way to split those ~ delimited fields.
I hadn’t heard of the getCustID function, so I did a little spelunking, and dontchaknow, that’s pretty cool!
Unfortunately, yeah it looks like they removed that from the menu so you would have to “Just Know” that these are there. Which kinda sucks.
Here’s a list of the ones that show up in the database.
You can still type them in, it doesn’t need to show up in that menu to use them. Which is a bummer in this new land of “No Code” that they are removing easy ways to get to things that you could use. If you’re cloud, I doubt you have a way to even see what these would be. (Unless @klincecum knows of a way to get them)
