|
да она есть у меня просто забыл вынести
и так в общем код
void getRangeValues()
{
QueryRun qr;
FlxPortJournal portJournal;
QueryBuildDataSource qbds = this.queryRun().query().dataSourceTable(tableNum(FlxPortJournal));
;
if (this.queryRun())
{
qbds = this.queryRun().query().dataSourceTable(tableNum(FlxPortJournal));
}
else
{
qbds = this.query().dataSourceTable(tableNum(FlxPortJournal));
}
qbds.addSortField(FieldNum(FlxPortJournal,ShipsType));
qbds.orderMode(OrderMode::GroupBy);
qbds.addSelectionField(fieldNum (FlxPortJournal,FlxNumPassengersTotalArrival),SelectionField::Sum);
qbds.addSelectionField(fieldNum(FlxPortJournal,FlxNumPassengersTotalDeparture),SelectionField::Sum);
qr = new QueryRun(queryRun.query());
while (qr.next())
{
portJournal = qr.get(tableNum(FlxPortJournal));
if (portJournal.FlxNumPassengersTotalArrival == 0 && portJournal.FlxNumPassengersTotalDeparture == 0)
continue;
}
}
не судите строго,
сейчас изучаю
Inside Microsoft Dynamics AX 4.0
|