public void executeQuery()
{
QueryBuildDataSource purchTableQueryRunQbds = purchTable_ds.queryRunQueryBuildDataSource();
QueryBuildRange purchIdRange = purchTableQueryRunQbds != null ? purchTableQueryRunQbds.findRange(fieldNum(PurchTable, PurchId)) : null;
// If there is specific purchase order id filter on the query run, we don't need the exist join with ProjTmpPurchListTable
if (purchIdRange != null)
{
QueryRun queryRun = purchTable_ds.queryRun();
if (queryRun != null && queryRun.query() != null)
{
QueryBuildDataSource tmpQbds = queryRun.query().dataSourceTable(tableNum(ProjTmpPurchListTable));
if (tmpQbds != null)
{
tmpQbds.enabled(false);
}
}
}
logisticsPostalAddressHeader_ds.validTimeStateUpdate(ValidTimeStateUpdate::Correction);
logisticsPostalAddressHeader_ds.query().validTimeStateDateTimeRange(DateTimeUtil::minValue(), DateTimeUtil::maxValue());
super();
}
[ExtensionOf(tableStr(PurchTable))]
final class PurchTablePOtotalValue_Extension
{
[SysClientCacheDataMethod]
display PurchLineAmount getPoTotalValue()
{
PurchLine purchLine;
select sum(LineAmount) from purchLine
where purchLine.PurchId == this.PurchId;
return purchLine.LineAmount;
}
}
[ExtensionOf(tableStr(PurchTable))]
final class PurchTablePOtotalValue_Extension
{
display PurchLineAmount GetPOtotalValue()
{
PurchTable purchTable;
PurchLine purchLine;
PurchLineAmount POtotalValue;
select sum(LineAmount) from purchline group by PurchId
where purchLine.PurchId == purchTable.PurchId;
POtotalValue = purchLine.LineAmount;
return POtotalValue;
}
}
André Arnaud de Cal...
292,160
Super User 2025 Season 1
Martin Dráb
230,962
Most Valuable Professional
nmaenpaa
101,156