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 :
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,662 Most Valuable Professional on at
    RE: Lookup to display all existing EDT's in D365 for operation

    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
    RE: Lookup to display all existing EDT's in D365 for operation

    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,662 Most Valuable Professional on at
    RE: Lookup to display all existing EDT's

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

  • Ashraf Shorman Profile Picture
    Ashraf Shorman 100 on at
    RE: Lookup to display all existing EDT's

    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
Priya_K Profile Picture

Priya_K 4

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 3

#3
Willem van Duren Profile Picture

Willem van Duren 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans