Why the modification is ok with salesline of sales order It Select from End Product Only
but no effect in purchline of purchase order
here is:
public client static void lookupItem(FormStringControl _ctrl)
{
Query query = new Query();
QueryBuildDataSource qbds;
QueryBuildDataSource qbdsJoin;
SysTableLookup sysTableLookup = sysTableLookup::newParameters( tableNum(InventTable), _ctrl);
QueryBuildRange qbr;
;
qbds= query.addDataSource( tableNum(InventTable));
qbdsJoin= qbds.addDataSource( tableNum(InventItemGroupItem));
qbdsJoin.relations( false);
qbdsJoin.fields().dynamic(NoYes::Yes);
qbdsJoin.addLink( fieldNum(InventTable, ItemId), fieldNum(InventItemGroupItem, ItemId));
qbdsJoin.joinMode(JoinMode::InnerJoin);
qbr=qbdsJoin.addRange(fieldNum(InventItemGroupItem,ItemGroupId));
// info(strFmt("hierarchyParent %1",_ctrl.hierarchyParent()));
qbr.value('EndProd');
qbr=qbdsJoin.addRange(fieldNum(InventItemGroupItem,ItemDataAreaId));
qbr.value(curext());
sysTableLookup.parmQuery(query);
sysTableLookup.addLookupfield( fieldNum(InventTable, ItemId),true);
sysTableLookup.addLookupfield( fieldNum(InventTable,NameAlias));
sysTableLookup.addLookupfield( fieldNum(InventTable,ItemType));
sysTableLookup.addLookupfield( fieldNum(InventTable,Product));
sysTableLookup.performFormLookup();
}
