Dynamics Community Forum Thread Details

Is it possible to change the order when create SysTableLookup?

I am trying to overwrite the lookup() method of a string field on a datasource.

Here is the code

SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(PurchLine), _lookupCtrl);

Query query = new Query();
QueryBuildDataSource queryBuildDataSourceLine = query.addDataSource(tableNum(PurchLine));
queryBuildDataSourceLine.addRange(fieldNum(PurchLine, isDeleted)).value(queryValue(NoYes::No));
sysTableLookup.parmQuery(query);

sysTableLookup.addLookupfield(fieldNum(PurchLine, PurchId));
sysTableLookup.addLookupfield(fieldNum(PurchLine, InventTransId), true);
sysTableLookup.addLookupfield(fieldNum(PurchLine, ItemId));

sysTableLookup.performFormLookup();

Hopefully, I want to make the order of columns is: purchId -> InventTransId -> ItemId, this is the default order if calling super() method.

But actually, the order is: InventTransId -> PurchId -> ItemId.

Seems like it put the returnItem to the first place by default.

So my question is that is it possible to change the order when create SysTableLookup?

Or I should create a lookup form instead of using SysTableLookup?

Quick Links