public void lookup(FormControl _formControl, str _filterStr)
{
//super(_formControl, _filterStr);
Query query = new Query();
QueryBuildDataSource qbdsInventDim_Tbl,qbdsInventSum;
SysTableLookup sysTableLookup;
Inventtransfertable inventtransfertable;
inventtransfertable = element.args().record();
sysTableLookup = SysTableLookup::newParameters(tableNum(inventDim),_formControl);
qbdsInventDim_Tbl = query.addDataSource(tableNum(InventDim));
qbdsInventSum = qbdsInventDim_Tbl.addDataSource(tableNum(InventSum));
qbdsInventSum.relations(false);
qbdsInventSum.addLink(fieldNum(InventDim,inventDimId),fieldNum(InventSum,inventDimId));
qbdsInventSum.joinMode(JoinMode::ExistsJoin);
qbdsInventSum.addRange(fieldNum(InventSum,AvailPhysical)).value(SysQuery::valueNot(0));
qbdsInventDim_Tbl.addGroupByAndSelectionField(fieldNum(InventDim,LicensePlateId));
qbdsInventDim_Tbl.addRange(fieldNum(inventdim , InventLocationId)).value(Inventtransfertable.InventLocationIdFrom);
qbdsInventDim_Tbl.orderMode(OrderMode::GroupBy);
sysTableLookup.parmUseLookupValue(false);
sysTableLookup.addLookupField(fieldNum(inventDim, LicensePlateId ));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}
[FormControlEventHandler(formControlStr(DT_ShiplicensePlateForm_dk, DT_Licenseship_dk_LicensePlateId), FormControlEventType::Lookup)]
public static void dt_Licenseship_dk_LicensePlateId_OnLookup(FormControl sender, FormControlEventArgs e)
{
FormRun element = sender.formRun();
FormStringControl locationIdCtrl = element.design().controlName(formControlStr(InventTransferOrders, LineViewHeader_InventLocationIdFrom));
Query query = new Query();
QueryBuildDataSource qbdsLicenseship_Tbl = query.addDataSource(tableNum(DT_Licenseship_dk));
QueryBuildDataSource qbdsInventTransferTable = qbdsLicenseship_Tbl.addDataSource(tableNum(InventTransferTable));
qbdsInventTransferTable.relations(true);
qbdsLicenseship_Tbl.addRange(fieldNum(InventTransferTable, InventLocationIdFrom)).value(queryValue(locationIdCtrl.text()));
// Just for debugging
info(qbdsLicenseship_Tbl.toString());
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(DT_Licenseship_dk), sender);
sysTableLookup.addLookupfield(fieldNum(DT_Licenseship_dk, LicensePlateId));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}
[FormControlEventHandler(formControlStr(DT_ShiplicensePlateForm_dk, DT_Licenseship_dk_LicensePlateId), FormControlEventType::Lookup)]
public static void DT_Licenseship_dk_LicensePlateId_OnLookup(FormControl sender, FormControlEventArgs e)
{
FormRun element;
FormControl formCtrl;
Query query;
SysTableLookup sysTableLookup;
QueryBuildDataSource queryBuildDataSource;
element = sender.formRun();
formCtrl = element.design().controlName(formControlStr(InventTransferOrders, LineViewHeader_InventLocationIdFrom));
query = new Query();
sysTableLookup = SysTableLookup::newParameters(tableNum(DT_Licenseship_dk), sender);
queryBuildDataSource qbdsLicenseship_Tbl = query.addDataSource(tableNum(DT_Licenseship_dk));
QueryBuildDataSource qbdsInventTransferTable = qbdsLicenseship_Tbl.addDataSource(tableNum(InventTransferTable));
qbdsInventTransferTable.relations(true);
sysTableLookup.addLookupfield(fieldNum(DT_Licenseship_dk,LicensePlateId ));
qbdsLicenseship_Tbl.addRange(fieldNum(InventTransferTable,InventLocationIdFrom)).value(formCtrl.valueStr());
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}
André Arnaud de Cal...
291,969
Super User 2025 Season 1
Martin Dráb
230,842
Most Valuable Professional
nmaenpaa
101,156