Code highlighting

Saturday, April 07, 2007

Add-On: Extended SysTableBrowser

Hello, readers.
Today I provide you with another tool for Dynamics AX developers. It is a modified version of the SysTableBrowser (See picture 1).
picture 1

After importing the project refresh the AOD (Tools\Development Tools\Application Objects\Refresh AOD)


  1. The table browser does not change its position when a different setup is selected. (Unlike standard system behavior in DAX 4.0)

  2. The AutoReport option was extended, and now you are able to select any of the table field groups (See Credits).

  3. Another selection option was added, providing the means to select any of the table fields to be shown in the grid. To do this, just press the ‘Select Fields’ button and select the fields you want displayed (See picture 2).

  4. Added a list of presets for the SQL window. (SELECT, UPDATE, DELETE). The list can be easily extended to include other presets you often use.

  5. Extra logic was added to the ExecuteSQL button, which executes the SQL string that the user has put into the SQL window. If it is a simple select (for example, generated by the SELECT preset), the ds query is executed instead of the sql string. This will bring back the sorting and filtering options that disappear after using the sql string query.
  6. Added the ability to sort columns by name or by id. In some cases (when, for example, you cannot find a specific field) it really helps out! (See picture 3)

picture 2
picture 3

Possible future improvements:

  1. Add display methods of the selected table to the list of fields in the select dialog.


The modification was inspired by a similar one performed by Nicolai Hillstrom for Dynamics AX 3.0. I moved it to DAX 4.0 and added some extra features I considered useful. One of them is implemented here (even thought I wasn’t able to download it and see how it is programmed).


  1. Hi Ivan,

    just now i download the file.when i import into axapta 3.0 sp 3, it show an error 'unknown file format'...

  2. Hello, Setiaji.
    The error you are getting is "correct".
    You are trying to import a project intended for DAX 4.0 into a 3.0 installation. That doesn't work.

    A project with similar functions for 3.0 can be found in this same post, only a bit lower down the text (it's a link)

  3. Do you mean this link ?

  4. Nope.

    This one:

    Of course, it has limited functionality compared to what is available here for DAX 4.0.

    If I have some spare time in the next couple of weeks, I might move this to 3.0 as well. I will add a post about it then.

    So stay tuned. :)

  5. Thx Ivan,i will wait,but meanwhile i downloaded from systomatics site.


Please don't forget to leave your contact details if you expect a reply from me. Thank you