Table Name Lookup in Ax 2012

Table Name Lookup in Ax 2012

10:14:00 AM
Description: Here is the code to create Table name lookup in ax 2012.


public void lookup()
{
    SysTableLookup              sysTableLookup = SysTableLookup::newParameters(tablenum(UtilidElements), this);
    Query                       query = new Query();
    QueryBuildDataSource        queryBuildDataSource;
    QueryBuildRange             nameQBR, typeQBR;
    ;
    sysTableLookup.addLookupfield(fieldnum(UtilidElements, Name));
    sysTableLookup.addLookupfield(fieldnum(UtilidElements, Id)); 

    queryBuildDataSource = query.addDataSource(tablenum(UtilidElements)); 

    nameQBR = queryBuildDataSource.addRange(fieldnum(UtilidElements, name)); 

    typeQBR = queryBuildDataSource.addRange(fieldnum(UtilidElements, recordType));
    typeQBR.value(SysQuery::value(UtilElementType::Table)); 

    sysTableLookup.parmQuery(query);
    sysTableLookup.performFormLookup();
}

Umesh Patel

Related Posts

Thanks for comments.....

:)
:(
hihi
:-)
:D
=D
:-d
;(
;-(
@-)
:P
:o
:>)
(o)
:p
:-?
(p)
:-s
(m)
8-)
:-t
:-b
b-(
:-#
=p~
$-)
(y)
(f)
x-)
(k)
(h)
cheer