|
кажется это он
qbds = qbds.addDataSource(tablenum(RDeferralsTrans));
qbds.orderMode(orderMode::GroupBy);
qbds.relations(true);
qbds.addSortField(fieldNum(RDeferralsTrans, TransDate));
qbds.addSelectionField(fieldNum(RDeferralsTrans, DeferralsId));
qbds.addSelectionField(fieldNum(RDeferralsTrans, DeferralsBookId));
qbds.addSelectionField(fieldNum(RDeferralsTrans, TransDate));
qbds.addSelectionField(fieldNum(RDeferralsTrans, Amount), SelectionField::Sum);
qbds.addRange(fieldNum(RDeferralsTrans, TransDate)).value(queryRange(dateStartYr(reportDate), reportDate));
qbds.addRange(fieldNum(RDeferralsTrans, DeferralsBookId)).value(rDeferralsBookId);
qbr = qbds.addRange(fieldId2Ext(fieldnum(RDeferralsTrans, Dimension), 5));
qbr.value(queryValue(dimensionCriteria5));
фильтр так сделать мне нужно сделать по аналитике
|