How to create a lookup on Dimension(SysDimesion) ENUM
Note:1. DimentionSetCombination is the table in Which dimension hierarchy stored
2. MachineHour is a customized table in this example, you can use your own logic in the same
3. fieldId2Ext is an X++ keyword which is used to access a particular array index value.
example: fieldId2Ext(fieldNum(DimensionSetCombination,Dimension),4)
public void lookup()
{
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tablenum(DimensionSetCombination), this);
Query query;
QueryBuildDataSource queryBuildDataSource;
QueryBuildRange queryBuildRange, queryBuildRangeDlvryWH;
;
sysTableLookup.addLookupfield(fieldId2Ext(fieldNum(DimensionSetCombination,Dimension),4), true);
query = new Query();
queryBuildDataSource = query.addDataSource(tablenum(DimensionSetCombination));
queryBuildRange = queryBuildDataSource.addRange(fieldId2Ext(fieldnum(DimensionSetCombination,Dimension),3));
queryBuildRange.value(MachineHours.CostElement);
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}
-Harry
Can this work on AX 4.0 as well?
ReplyDelete