Table Browser

How to use the table browser in the D365O web interface.

This neat tip can be found in a few other blogs, but I’ve found it so useful that I want to increase its visibility… and put it together with some other useful info in one place.

Although there isn’t a direct method to get to it through the UI, you can open the “table browser” (which you might recognize from inside Visual Studio) to look at the contents of one of the back end database tables. You’ve got to take your URL and change the part after the slash like so:

http://<host>/Default.htm?mi=SysTableBrowser&tablename=<tn>&cmp=<company>

Obviously, you need to fill in the appropriate <host>, <tn>, and <company>; for example:

https://usnconeboxax1aos.cloud.onebox.dynamics.com/Default.htm?mi=SysTableBrowser&tablename=CompanyInfo&cmp=DAT

…will produce, on your dev VM, the table browser for table CompanyInfo and the DAT company:

Table Browser

If you see this tip elsewhere, you will sometimes see a few other URL parameters in there; lng=<language>limitednav=true (hides parts of the UI like the navigation pane and filters), and prt=<partition> (deprecated partition functionality) are commonly added. I don’t think you are likely to need them, but you can look at other blog posts explaining what those (and other) optional parameters do.