hello, I can use some special sql functions in x++ ?,for example group by rollup, substring, concat or +?
*This post is locked for comments
No, you need to use X++ functions when writing X++ code.
But there are cases where you can use SQL, and when writing SQL code, you can use SQL functions. I mean computed columns in particular.
If you have a specific scenario in mind and you don't know how to design a solution, explain the scenario to us.
André Arnaud de Cal...
291,971
Super User 2025 Season 1
Martin Dráb
230,846
Most Valuable Professional
nmaenpaa
101,156