Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
In older NAV versions, developers and users(with required permissions) can view the table data by running tables directly from the Object Designer of NAV Development Environment. See below screen.
But now with Business Central we have new Modern Development Environment for AL programming. For more information, https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-reference-overview
Let’s see how we can View Table Data in Microsoft Dynamics 365 Business Central Web Client.
For developers, administrators, and support personnel, it can be useful to inspect table data in the tenant database, particularly when debugging or troubleshooting. To support this need, you can view table objects in the Web client.
NOTE : The table appears as read-only in the client, so modifications, insertions and deletions cannot be made.
IMPORTANT : Data in the tables can be sensitive. Be sure to follow your organization’s guidelines for handling such data.
Whether viewing the table directly from the client or from Visual Studio Code, your Dynamics 365 user account must have the following permissions:
Any end-user that is assigned these permissions will be able to view that table in the browser.
To view a table, you add the table=<TableID> parameter to the client’s address (URL), replacing <TableID> with the ID of the table that you want to view.
For example, if your URL starts with https://businesscentral.dynamics.com , then to view table 18 Customer in your current company, you could use the following URL:
Or for a specific company, such as “CRONUS Inc.”:
Note the use of & when table=<TableID> is not located directly after the domain name.
See below example, how we can run table object directly from the client running on docker container.
You can configure an AL project to view a table when you publish or debug the project (pressing F5 or Ctrl+F5).
In the launch.json file for the project, set the “startupObjectType” parameter to “table” and the “startupObjectId” parameter to the ID of the table. For example:
Output will be
You cannot view virtual tables or the following system tables:
Source of Information : https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-view-table-data
The post Viewing Table Data in Microsoft Dynamics 365 Business Central appeared first on Jatin Patel - Microsoft Dynamics NAV.
Business Applications communities