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

Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
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 239,660 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 239,660 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

News and Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 21

#2
dekion Profile Picture

dekion 4

#2
Virginia99 Profile Picture

Virginia99 4

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans