#msdyn365bc 2022 Release Wave 2 - See the primary key for table fields in IntelliSense.

Hi Readers,

In this series we are discussing what's new in Business Central 2022 (Wave 2) a.k.a BC21.

This article we will discuss about - See the primary key for table fields in IntelliSense.

With this series we will understand what's new the product and learn it.

Hope you like the series, please add comments to article.

#msdyn365bc #2022RW2

Business Value - 

When you work with table fields in code, it's important to know if the fields are primary key members, as well as the sequence of the fields in the primary key. To provide contextual information, and avoid tedious steps on navigating to table definitions, primary key members are now marked with a (PKx) in the IntelliSense list, where x is a sequential number that indicates the order of the field in the key.

Feature details - 

• The information makes it easier to identify the table fields that make up the primary key as well as the sequency of these fields in the key.

• While working on Extension Development, it's hard to remember sequence of fields while doing a Setrange and Get Statement. For Some tables its easier but it adds an additional step to check the table Primary Key Fields. 

• With this new feature IntelliSense will highlight fields with PK(x) where x is the order of fields as part of primary key.

Sample Sales Header Primary Key Fields

As Sales Header has two fields in Primary key - Document Type and No., those fields are highlighted as PK1 & PK2.

Sample Invt. Posting Buffer Primary Key Fields

Inv. Posting Buffer has multiple fields in primary key. There are 09 fields in the primary key of table. These fields are highlighted from PK1 to PK9.

  

What Would have been great?

• If Primary key fields are listed on top of intelliSense, that would have been great to find these fields during coding.

• If top of table in intelliSense, if PK1 to PKx fields are listed that will be great for developers.

For other articles related to What's New in Business Central 21, refer here.

Hope you learn and will be able to utilize this feature as Business Central 21 is available.  

Regards,
Saurav Dhyani
www.sauravdhyani.com 
https://www.youtube.com/@sauravdhyani