Skip to main content

#msdyn365bc - Returning complex types.

Hi Readers,

In this article we will talk about one of the cool feature that is available with release of #msdyn365bc 2021 Release Wave 1 (a.k.a BC 18).

AL Code was introduced from C/AL and with initial releases it was exactly same as C/AL Code. But with great community support and feedback to Microsoft, Microsoft is able to make it modern with new versions.

If you are a regular reader then you would have noticed that I keep on saying that we need to unlearn NAV or C/AL  before we start working on AL. The Reason I keep on saying this is because there are better ways to code and that is possible with enhancement in the product.

One of such long waited feature is what we are going to discuss today.

As NAV Developer we always hated how functions were able to return limited data types like code, Text, Boolean etc.

With Business Central 2021 Release Wave 1, most types can be returned from procedures – both user-defined types and most built-in types. 

Now We can write any procedure and Return any Data Type Including objects like record, Codeunit etc.

What Does That Mean?

In past we are limited to return 25 data Types as listed below.


With Business Central 2021 Release wave 1, We can return any defined data types like below. 


That Means that we can return any possible simple / complex Data type in Business Central.

Examples - 

If I have to return all Customers where Blocked in Blank we can write something like this.


If I have to return all customer ledger entries for a specific customer we can write something like

We can also use the complex return type directly as part of other expressions like Get Due Date of a Sales Order Created from a procedure.


This article was discussed in last #bcopendiscussion. You can find recording below.

Cool isn’t it?

Let me know your views as comment to article.

Regards,
Saurav Dhyani

www.sauravdhyani.com

Comments

Popular posts from this blog

VIEW SERVER STATE permission on SQL Server?

Hi all, Sometime While trying to Login into a database we face an error message as shown below. --------------------------- Microsoft Dynamics NAV Classic --------------------------- You cannot start Microsoft Dynamics NAV Classic because you do not have the VIEW SERVER STATE permission on SQL Server. Contact your system administrator. --------------------------- OK    ---------------------------

NAV 2013 R2 - Cumulative update 12 Released.

Hi all, Please find below the details of  Cumulative Update 12 released for Microsoft Dynamics NAV 2013 R2. Title - Cumulative Update 12 for Microsoft Dynamics NAV 2013 R2 Build No. - 38053 Release Date - October, 2014 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK, RU Download Link Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5.

NAV 2013 Upgrade Part III - Data Upgrading.

Hi all, As per agenda we need to discuss the data upgrade in NAV 2013. The process is similar to what used to be till NAV 2009 R2 but with some changes. Let's start the process. Remember -  1) You can only upgrade a database to NAV 2013 from NAV 2009 SP1 / R2 SQL Only. 2) The Synchronization of users with SQL Server is no more required.