CODEWITHSUNDEEP
dynamics-ax-2012aot
Brad
Brad

Reputation: 1369

Dynamics AX 2012 AOT Object Lookup

Anyone have sample lookup code for AOT objects? (or know where to find the one they use for the AX properties window)

I need to replicate the functionality that you see in several fields in the properties window. The ExtendedDataType field is a good example. Type a few letters, hit the down arrow, and a filtered list of AOT ExtendedDataType objects appears.

I've been trying to use treeNode findChildren to build my custom lookup list, but it is very slow. Whatever method AX is using happens instantly.

Thanks

Upvotes: 0

Views: 1983

Answers (2)

jhlange
jhlange

Reputation: 48

Try this:

Dictionary d = new Dictionary();
int i;
int cnt = d.tableCnt();
TableId tableId;
str nameForLookup;

for (i = 1; i <= cnt; i++)
{
    tableId = d.tablecnt2id(i);
    nameForLookup = tableid2name(tableId);
}

Queries to the Model/Util*Element tables will not be cached, and are relatively slow due to the number of records that they contain.

There may be other factors slowing down execution as well. If you are on 2012, for lookups, you may want to build a temp table with an XDS() method, which populates itself using the above code, then you can simply select from that table (and it will be cached for the session):

  1. create a SQL Temp table (e.g. with a name like MyTableLookup), add a name column

  2. add a method like this:

    public RefreshFrequency XDS()

    {

    MyTableLookup tableLookup;

ttsbegin;
// Use the above code to insert records into tableLookup
ttscommit;

return RefreshFrequency::PerSession;

    }

  3. bind your form to MyLookupTable

Upvotes: 1

j.a.estevan
j.a.estevan

Reputation: 3097

You may develop an estándar EDT linked to the UtilElement Table properly filtered. This will show a list of objects and will have same functionality of all table-linked text fields.

Upvotes: 0

Related Questions