Saturday, August 4, 2007

CASE / DECODE in Dynamic AX Queries / Select

For those of you who are used to using CASE / DECODE in SQL i have some information.

They are not supported in Dynamics AX. Now what to do to get the work done for which these constructs are used in SQL.

To go for the work around, first we should understand what they are used for in SQL queries. They are used for making decision about which information to display based on other columns information in data got as a result of querying the database.

The same work can be done if we used DISPLAY function in X++. They will definitely not be used in Select / Query directly but in the form, report etc that the result of query is used in. For the information about display function, you can read Inside Dynamics AX.


No comments: