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) / Lookup to display all ...
Microsoft Dynamics AX (Archived)

Lookup to display all existing EDT's

(0) ShareShare
ReportReport
Posted on by naveen singh 780

Hi All,

I have to create two lookup's that will display all the EDT's and BaseEnum's in D365. I have gone through the SysModelElement table, but there is no data in this table. In AX2012, there is one EDT SysXppType for the same. But this does not exist in D365. Is there anyone has any idea about this how we can achieve this.

Thanks in Advance

Naveen Singh

*This post is locked for comments

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

    You should be able to get this list from the new metadata API. Then simply put it into a temporary table and use the table for your lookup. Note that the list will be pretty long.

    There aren't model tables because application objects aren't stored in database anymore. There is TypeIdTable, but I don't think is exposed in any way. It's used internally by AX kernel to store the mapping between names and IDs.

  • naveen singh Profile Picture
    naveen singh 780 on at

    Hi Martin,

    Thank you fir your help. 

    The post is regarding to display the form control node name. Can you please let me know how we can do this for BaseEnum and EDT's.

    Regards,

    Naveen

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

    Use MetadataSupport::EdtNames() and MetadataSupport::EnumNames().

  • Ashraf Shorman Profile Picture
    Ashraf Shorman 100 on at

    This is a sample code,

    public void PerformExtendedTypeLookup(FormControl _Control)

    {

       Query                   query          = new Query();

       QueryBuildDataSource    queryBuildDataSource;

       QueryBuildRange         queryBuildRange;

       SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(UtilElements), _Control);  

       sysTableLookup.addLookupField(fieldNum(UtilElements, Name), true);

       sysTableLookup.addLookupField(fieldNum(UtilElements, RecordType));

       queryBuildDataSource = query.addDataSource(tableNum(UtilElements));

       queryBuildRange = queryBuildDataSource.addRange(fieldNum(UtilElements, RecordType));

       queryBuildRange.value(strFmt('%1',UtilElementType::ExtendedType));

       sysTableLookup.parmQuery(query);

       sysTableLookup.performFormLookup();

    }

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