AX2012 R3 - Field Lookup is based on all the fields found in the table referenced in the variable field entry.

/// <remarks>

/// Lookup is based on all the fields found in the table referenced in the variable field entry.

/// </remarks>


public void lookup()

{
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(UtilElements), this);

Query query = new Query();


QueryBuildDataSource queryBuildDataSource;
sysTableLookup.addLookupfield(fieldNum(UtilElements, Name));

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

queryBuildDataSource.addRange(fieldnum(UtilElements, RecordType)).value(enum2str(UtilElementType::TableField));

queryBuildDataSource.addRange(fieldnum(UtilElements, RecordType)).value(enum2str(UtilElementType::TableInstanceMethod));

queryBuildDataSource.addRange(fieldnum(UtilElements, ParentId)).value(int2str(tablename2id(MCRUpSellVarSys.VariableTable)));

queryBuildDataSource.orderMode(OrderMode::GroupBy);

sysTableLookup.parmQuery(query);

sysTableLookup.performFormLookup();

}

Comments