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

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    ---------------------------
10 comments
Read Complete Article »

BC 21 and Higher - PowerShell Cmdlet (Replacement of Business Central Administration).

Hi Readers, As discussed in last article about deprecating of Business Central Administration, there are few common actions that we use in administration till Business Central 20. For our on-prem customers, we will still require doing activities. As Microsoft suggest we need to start using PowerShell cmdlet.    Let's see how to do those via PowerShell, or Administration Shell. I will be keep adding commands as you comment to this article.
1 comment
Read Complete Article »

Send Mail with Attachment From Navision.

Hi all, We have seen how to save a report into PDF and how to send mail to a customer. Let's link these two post in one i.e. Mailing statement to a customer into PDF Format. This article is part of the Series. Please Refer  Table of Content here . If you have the old objects set let me brief you what I will be changing - 
6 comments
Read Complete Article »