How to browse table in dynamics 365?

In the previous versions, to browse table just open AOT and access table

but in dynamics 365, you have multiple options

1-you can browse table from the Visual Studio as the following 

 create a project and search on your table in application explore



as you see, after the search, you will find all objects that contain this name (Web application)

to open your table, just right click and click open table in browser  or click ALT+O


2-you can call the Menuitem SysTableBrowser.

One of the available URL Parameters is to call the Menuitem SysTableBrowser.



Knowing the table name is essential to use this syntax, otherwise no success. Finding the right table allows editing in free text fields or choosing from underlying master table values. 


To access to table data you need the appropriate user rights inside your environment. Once you reach the table browser you can personalize the form as used for each table you call. So adjust and hide columns as you need it for your task. 




3-you can access the table from the chrome table browser table tool 

it is currently available for the Chrome browser only

after that, you can search by table name and data area id as the below

this tool is very powerful, you see more information about every table like  table label, table group, table type and this object view or table, form reference,,, etc

also after the search, you apply some filters to the retrieved data  as the below


You can browse the entire built-in table list with links to open Table browser directly.
You can view/edit records using Table browser without opening the Visual Studio.
You can hide system field using Table browser without opening the Visual Studio.


note: The access permissions can be controlled by setting up roles from within AX.




Comments

  1. Note that the table browser is read-only in the production D365FO environment.

    ReplyDelete
  2. thank you for this usefull topic

    ReplyDelete
  3. I wish to show thanks to you just for bailing me out of this particular trouble. As a result of checking through the net and meeting techniques that were not productive, Same as your blog I found another one Inbounce Marketing .Actually I was looking for the same information on internet for Inbounce Marketing and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details.

    ReplyDelete
  4. Many thanks Mr. Mahmoud for valuable information

    ReplyDelete
  5. This blog is very helpful and informative for this particular topic. I appreciate your effort that has been taken to write this blog for us. Microsoft Certified: Dynamics 365 Supply Chain Management Functional Consultant Associate

    ReplyDelete

Post a Comment