![]() |
#30 |
Участник
|
Всё-таки не до конца понятно, как применить этот динамический фильтр. В методе initQuery находится мой запрос и динамический фильтр на него не действует, то есть, если выбираю критерии - в запрос они не добавляются...
Может быть его нужно как-то активизировать или что ? Подскажите, пожалуйста. Метод initParmDefault X++: public void initParmDefault() { this.initQuery(); super(); } X++: void initQuery() { Query query = new Query(); QueryBuildDataSource qbds_vendsp,qbds_vendsplist,qbds_vendinvoice; QueryBuildRange qbr; ; qbds_vendsplist = query.addDataSource(tablenum(VendSpListTrans)); qbds_vendsplist.orderMode(OrderMode::GroupBy); qbds_vendsplist.addSelectionField(fieldnum(VendSpListTrans,InternalSp)); qbds_vendsplist.addSelectionField(fieldnum(VendSpListTrans,SpClosed)); qbds_vendsplist.addSelectionField(fieldnum(VendSpListTrans,ItemId)); qbds_vendsplist.addSelectionField(fieldnum(VendSpListTrans,SpQty)); qbds_vendsplist.addSortField(fieldnum(VendSpListTrans,InternalSp)); qbds_vendsplist.addSortField(fieldnum(VendSpListTrans,Itemid)); qbds_vendsplist.addSortField(fieldnum(VendSpListTrans,SpClosed)); qbds_vendsplist.addSortField(fieldnum(VendSpListTrans,SpQty)); //->скрытие полей-индексов в динамических фильтрах qbr = qbds_vendsplist.addRange(fieldnum(VendSpListTrans,InternalSpTrans)); qbr.status(RangeStatus::Hidden); //<- qbds_vendinvoice = qbds_vendsplist.addDataSource(tablenum(VendInvoiceTrans)); qbds_vendinvoice.orderMode(OrderMode::GroupBy); qbds_vendinvoice.addSelectionField(fieldnum(VendInvoiceTrans,ItemId)); qbds_vendinvoice.addSelectionField(fieldnum(VendInvoiceTrans,InternalSp)); qbds_vendinvoice.addSortField(fieldnum(VendInvoiceTrans,ItemId)); qbds_vendinvoice.addSortField(fieldnum(VendInvoiceTrans,InternalSp)); // qbds_vendinvoice.addSortField(fieldnum(VendInvoiceTrans,Qty)); qbds_vendinvoice.addSelectionField(fieldnum(VendInvoiceTrans,Qty),SelectionField::Sum); qbds_vendinvoice.addLink(fieldnum(VendSpListTrans,InternalSp), fieldnum(VendInvoiceTrans,InternalSp)); //->скрытие полей-индексов в динамических фильтрах qbr = qbds_vendinvoice.addRange(fieldnum(VendInvoiceTrans,PurchId)); qbr.status(RangeStatus::Hidden); qbr = qbds_vendinvoice.addRange(fieldnum(VendInvoiceTrans,InvoiceDate)); qbr.status(RangeStatus::Hidden); qbr = qbds_vendinvoice.addRange(fieldnum(VendInvoiceTrans,InvoiceId)); qbr.status(RangeStatus::Hidden); qbr = qbds_vendinvoice.addRange(fieldnum(VendInvoiceTrans,LineNum)); qbr.status(RangeStatus::Hidden); qbr = qbds_vendinvoice.addRange(fieldnum(VendInvoiceTrans,numberSequenceGroup)); qbr.status(RangeStatus::Hidden); qbr = qbds_vendinvoice.addRange(fieldnum(VendInvoiceTrans,InternalInvoiceId)); qbr.status(RangeStatus::Hidden); //<- qbds_vendsp = qbds_vendinvoice.addDataSource(tablenum(VendSpListJour)); qbds_vendsp.addSelectionField(fieldnum(VendSpListJour,SpClosed)); qbds_vendsp.addRange(fieldnum(VendSpListJour,EmplId)); qbds_vendsp.addLink(fieldnum(VendInvoiceTrans,InternalSp),fieldnum(VendSpListJour,InternalSp)); info(qbds_vendsplist.toString()); queryRun = new SysQueryRun(query); Последний раз редактировалось user_ax; 10.06.2013 в 11:53. |
|
Теги |
runbasereport, диалог, динамическая форма, периодическая операция, программно |
|
|