Table browser in Dynamics 365

Normally when I need the table browser in Dynamics 365 I use a Chrome extension called “Table Browser Caller for D365FO“. Often you end up working in Incognito mode when having to access environments with a different AAD account. That requires you to make it available in Incognito mode:

Extensions

BUT … what the extension does isn’t magic. What it does however is offering a very easy approach to building an URL that I never can remember. And when working in a browser without that extension you can write the URL change yourselve. So I figured that if I wrote it here I might remember it better or at least help somebody else remember it.

Add this to the URL to get the table browser: &mi=SysTableBrowser&TableName=. This will give you something like this:

Table_browser

Notice, that the table browser is being changed in a couple of areas compared to AX 2012. This means that changing data through the table browser is not allowed in production environments for example. Nice in regards to data consistency, but missed when having to dirty-fix data. 🙂

Advertisements

Queries included in the URL in Dynamics 365 for Operations

Occasionally you need to pass a link to a form in Dyn365O and you would like to include the query you used to filter out the relevant data.

In order to do this you need to flip a switch in your user options.user-options

When that is set to Yes the query will be added in unreadable format in the URL. In this case we are going to add a filter on Workers.

Open the Workers form and click the funnel:

workers-add-filter

Add a filter. In this case I want all workers with personnel number starting with 0001:

workers-get-url

After clicking Apply the parameter q is added to the URL. The complete URL can now be copied and opened in another browser. In this case I have copied from my MacBook to a Windows 10-machine and after login I get the same data as on my Mac:

open-url-in-different-system

The URL is a bit massive and brings back memories of Sharepoint URLs back in the days; but it does the trick.