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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Library of Predefined ...
Microsoft Dynamics AX (Archived)

Library of Predefined SQL Queries

(0) ShareShare
ReportReport
Posted on by raff 1,236

hi

I have been asked to write a sql query to return all fields stored against an Item.

which is obviously easier said than written given the amount of tables involved, which has me wondering does anyone know of a library resource of such already written queries on the web?

does any resource like this exist?

mal

*This post is locked for comments

I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 237,882 Most Valuable Professional on at

    What's your definition of "fields stored against an Item"?

  • raff Profile Picture
    raff 1,236 on at

    hi Martin

    I mean every possible field you can view in ax when you enter the item

    from unit costs, financial dimensions, gtins

    basically any information it has, does Microsoft have any prebuilt views like this?

    mal

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 237,882 Most Valuable Professional on at

    No, there is not such a view; it doesn't sound very useful.

    If you want all tables from a given form, look at its data sources.

  • raff Profile Picture
    raff 1,236 on at

    maybe I am just being lazy :)? but it sounds like something useful that someone would already have !

  • Martin Dráb Profile Picture
    Martin Dráb 237,882 Most Valuable Professional on at

    The problem is that "everything" is too vague and subjective. You could end up with almost all AX tables, because they are in some way related to items. Any real problem requires some particular set of data and the scope of "everything" depends on context.

    Maybe you would find useful queries like AxdItem, but it's impossible to say whether it meets the requirement of your particular business scenario.

  • raff Profile Picture
    raff 1,236 on at

    hi Martin

    i think you are right, it would be to vague and subjective and it would be a bit of mess!

    in fairness I didn't even think of looking up the form name and taking the datasources from there so you have already been very helpful to me :)

    thanks

    mal

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans