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();
}
/// 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
Post a Comment