Skip to main content

#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.  

Labels:
Location: House No. 1, Shivlok Colony, 2, near Himalayan Academy Post Office, Shivlok Colony, Sewla Kalan, Majra, Dehradun, Uttarakhand 248171, India

Comments

Post a Comment

Popular posts from this blog

Microsoft Dynamics NAV 2016 - How to Configure Phone Client.

Hi All, In this article we will discuss how we can connect Microsoft Dynamics NAV 2016 with New Client Launched i.e. Phone Client. This Article Contain Steps for a Android Phone as I have Only Android Phone. I am doing it having all tiers on my windows 8 machine, steps remain same for multiple servers but issues might be different. What we Need (Other what we discuss in this article) -  The Service Tier should be on Public IP . Some of the Data-card does not Provide you Public IP. check it for sure.
28 comments
Read Complete Article »

How to Set Up NavUserPassword Authentication in Business Central.

Hi Readers, In this article we will discuss steps to Setup NAVUserPassword in Business Central on-prem. NavUserPassword is an authentication method that's handled by Business Central Server, but isn't based on Windows users or Active Directory. Each user is set up with a username and password that's configured inside Business Central only. The user is prompted for username/password credentials when they start the client. #msdyn365bc, #credentialtype
1 comment
Read Complete Article »

MSDYN365BC - Data Upgrade To Microsoft Dynamics 365 Business Central on premises.

Hi Readers, We have already talked about the number of steps for upgrading to Business Central on Premises from different NAV versions. After that article, I received multiple requests for an article which list down steps for Data Migration. In this article, we will discuss steps of data migration to MSDYN365BC (on-Prem) from NAV 2017. For this article, I am considering a Cronus Demo Database without any customization. For an actual upgrade project, we will have to complete object merge using compare and Merge process. After the Merge Process, the next step is data migration. Let's discuss those steps. Direct Upgrade to Microsoft Dynamics 365 Business Central (on-Prem) is from following versions - 1. NAV 2015. 2. NAV 2016. 3. NAV 2017. 4. NAV 2018.
21 comments
Read Complete Article »