Вот так:
PHP код:
Query query = new Query();
QueryBuildDataSource qbds;
QueryBuildRange qbr;
QueryRun qr;
TableId tableId;
FieldId fieldId;
FieldId linkedfieldId;
LedgerTable ledgerTable;
LedgerTrans ledgerTrans;
LedgerTrans ledgerTransCount;
;
info("1st method:");
while select count(RecId)
from ledgerTrans
group by AccountNum
{
info(strfmt("%1 %2",ledgerTrans.AccountNum, ledgerTrans.RecId));
}
info("2nd method:");
query = new Query();
qbds = query.addDataSource(tableId);
qbr = qbds.AddRange(fieldId);
tableId = tablenum(LedgerTrans);
fieldId = fieldnum(LedgerTrans,AccountNum);
while select AccountNum
from ledgerTrans
group by AccountNum
{
qbr.value(ledgerTrans.AccountNum);
qr = new QueryRun(query);
info(strfmt("%1 %2",ledgerTrans.AccountNum, SysQuery::countTotal(qr)));
}
С Уважением,
Георгий.