qbds = query.addDataSource(tableNum(VendInvoiceJour));
qbds.addRange(fieldnum(VendInvoiceJour, InvoiceDate)).value(QueryRange('2011/03/01','2011/03/20'));
qbds.addRange(fieldnum(VendInvoiceJour, CENTERPROFIX)).value(QueryValue('008-001'));
qbds = qbds.addDataSource(tableNum(VendInvoiceTrans));
qbds.relations(false);
qbds.joinMode(joinMode::InnerJoin);
qbds.addLink(fieldnum(VendInvoiceJour, PurchId), fieldnum(VendInvoiceTrans, PurchId));
qbds = qbds.addDataSource(tableNum(PurchTable));
qbds.relations(false);
qbds.joinMode(joinMode::InnerJoin);
qbds.addLink(fieldnum(VendInvoiceJour, PurchId), fieldnum(PurchTable, PurchId));
qbds = qbds.addDataSource(tableNum(PurchLine));
qbds.relations(false);
qbds.joinMode(joinMode::InnerJoin);
qbds.addLink(fieldnum(PurchTable, PurchId), fieldnum(PurchLine, PurchId));
qbds = qbds.addDataSource(tableNum(VSN_PURCHORDERJOUR));
qbds.relations(false);
qbds.joinMode(joinMode::InnerJoin);
qbds.addLink(fieldnum(PurchLine, VSN_PURCHORDERID), fieldnum(VSN_PURCHORDERJOUR, ORDERID));
qbds.addRange(fieldnum(VSN_PURCHORDERJOUR, CENTERPROFIX)).value(QueryValue('008-001'));
// правильнее
qbds = query.addDataSource(tableNum(VendInvoiceJour));
qbds.addRange(fieldnum(VendInvoiceJour, InvoiceDate)).value(QueryRange('2011/03/01','2011/03/20'));
qbds.addRange(fieldnum(VendInvoiceJour, CENTERPROFIX)).value(QueryValue('008-001'));
qbds = qbds.addDataSource(tableNum(VendInvoiceTrans));
qbds.relations(false);
qbds.joinMode(joinMode::InnerJoin);
qbds.addLink(fieldnum(VendInvoiceJour, PurchId), fieldnum(VendInvoiceTrans, PurchId));
qbds.addLink(fieldnum(VendInvoiceJour, PurchId), fieldnum(VendInvoiceTrans, PurchId));
qbds.addLink(fieldnum(VendInvoiceJour, InvoiceId), fieldnum(VendInvoiceTrans, InvoiceId));
qbds.addLink(fieldnum(VendInvoiceJour, InvoiceDate), fieldnum(VendInvoiceTrans, InvoiceDate));
qbds.addLink(fieldnum(VendInvoiceJour, numberSequenceGroup), fieldnum(VendInvoiceTrans, numberSequenceGroup));
qbds.addLink(fieldnum(VendInvoiceJour, InternalInvoiceId), fieldnum(VendInvoiceTrans, InternalInvoiceId));
qbds = qbds.addDataSource(tableNum(PurchLine));
qbds.relations(false);
qbds.joinMode(joinMode::InnerJoin);
qbds.addLink(fieldnum(VendInvoiceTrans, InventTransId), fieldnum(PurchLine, InventTransId));
qbds = qbds.addDataSource(tableNum(VSN_PURCHORDERJOUR));
qbds.relations(false);
qbds.joinMode(joinMode::InnerJoin);
qbds.addLink(fieldnum(PurchLine, VSN_PURCHORDERID), fieldnum(VSN_PURCHORDERJOUR, ORDERID));
qbds.addRange(fieldnum(VSN_PURCHORDERJOUR, CENTERPROFIX)).value(QueryValue('008-001'));
|