web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Need to list down the tables with Module wise in Dynamics 365 for Operation

(0) ShareShare
ReportReport
Posted on by 135

Hi All,

We need to list down the tables with Module wise in Dynamics 365 for Operation.

If there is any possible way to do that??

Thanks,

Karthick.M

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    guk1964 Profile Picture
    10,886 on at
    RE: Need to list down the tables with Module wise in Dynamics 365 for Operation

    The Application code consists of many packages including the standard ones that Microsoft shipped (ApplicationFoundation, ApplicationPlatform, ApplicationSuite, Calendar etc) and any custom packages.  In individual package folder, a folder named "Descriptor" is present that  holds the information of the package, the packages it references and the modes that are part of this package. The file is in XML format. Each package consists of one or more models (Model 1, Model 2...Model n). In the model folder there is a folder for each AX object type (AxClass, AxEDT, AxTable etc). The information (code etc) for individual objects is stored in a XML file.

    In AX7 the application code is saved in file system in a directory and is called PackageDirectory.  The location of directory (along with other settings) is saved in a web.config file. In IIS right click on the site "AOSWebApplication" and click on Explore. In the folder, find web.config, open it with notepad and search for "Aos.PackageDirectory". This will have the location of application directory. e.g. C:\Packages. This file also contains the information of the business database location.

    A file based model store allows for quick search - xml allows  complex searches using XPath and XQuery to find properties.  There is a tool –‘ basex’ -  which is a light weight xml database engine and it provides very powerful query and searching.

    Download it from the site http://basex.org (mentioned by Peter Villadsen’s session at the recent tech conference. Mining the Metadata and Authoring X++ Best Practice Rules in Microsoft Dynamics AX) Create a new Database and select the Packages folder. Make sure to tick skip corrupt files because s there is 1 file it is not well formatted xml.

  • karthickarden Profile Picture
    135 on at
    RE: Need to list down the tables with Module wise in Dynamics 365 for Operation

    Thank you Martin...

  • Verified answer
    Martin Dráb Profile Picture
    236,160 Most Valuable Professional on at
    RE: Need to list down the tables with Module wise in Dynamics 365 for Operation

    It all depends on your definition of "module". It may be a model or a package. It may be a configuration key. It may be a prefix of table names. All these things can be done. But there surely can be definition of module that aren't stored in metadata and therefore can't be evaluated automatically.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#1
Guy Terry Profile Picture

Guy Terry 2 Moderator

#1
Rahul Shah Profile Picture

Rahul Shah 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans