I have added lookup method on StringEdit(InvoiceIdMultiselect) formcontrol as follows:
public void lookup()
{
Query query = new Query();
QueryBuildDataSource queryBuildDataSource;
queryBuildDataSource = query.addDataSource(tableNum(VendInvoiceJour));
queryBuildDataSource.addRange(fieldNum(VendInvoiceJour,PurchId)).value(PurchId.valueStr());
queryBuildDataSource.addSelectionField(fieldNum(VendInvoiceJour, InvoiceId));
queryBuildDataSource.addSelectionField(fieldNum(VendInvoiceJour, PurchId));
msCtrl = SysLookupMultiSelectCtrl::constructWithQuery(this.formRun(), InvoiceIdMultiselect, query);
//super();
}
On testing, when I am changing PO, lookup values are not updating,
But when I am closing the form and reopening, it updates the data.
Any solution?
Resolved
public void lookup() { //super(); Query query = new Query(); QueryBuildDataSource qbdsVendInvoiceJour, qbdsVendTrans; qbdsVendInvoiceJour = query.addDataSource(tableNum(VendInvoiceJour)); qbdsVendTrans = qbdsVendInvoiceJour.addDataSource(tableNum(VendTrans)); qbdsVendTrans.relations(true); qbdsVendInvoiceJour.addSelectionField(fieldNum(VendInvoiceJour, InvoiceId)); qbdsVendInvoiceJour.addSelectionField(fieldNum(VendInvoiceJour, PurchId)); qbdsVendInvoiceJour.addSelectionField(fieldNum(VendInvoiceJour, DueDate)); qbdsVendTrans.addSelectionField(fieldNum(VendTrans, Voucher)); qbdsVendTrans.addSelectionField(fieldNum(VendTrans, TransDate)); qbdsVendTrans.addSelectionField(fieldNum(VendTrans, PromissoryNoteStatus)); qbdsVendInvoiceJour.addRange(fieldNum(VendInvoiceJour,PurchId)).value(PurchId.valueStr()); msCtrl = SysLookupMultiSelectGrid::construct(this,this); msCtrl.parmQuery(query); msCtrl.run(); //msCtrl = SysLookupMultiSelectCtrl::constructWithQuery(this.formRun(), this, query); }
Hi Ashraf,
Override the modified method of your form control for which the lookup is crated and add the below code after super()
this.text(con2str(msctrl.getSelectedFieldValues(), ';'));
Note: your msctrl should be declared as global variable.
You can refer the below post explaining the same for D365 FO
Yes I have tried but did not work.
Hi Ashraf, Have you checked this thread. Hope it helps.
André Arnaud de Cal...
292,162
Super User 2025 Season 1
Martin Dráb
230,962
Most Valuable Professional
nmaenpaa
101,156