Finance | Project Operations, Human Resources, ...

Multiselect lookup data is not updating

(0) Share

Report

Posted on by Ashraf_ahk

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?

All responses (4)

Answers (0)

Sort by

Suggested answer

Mohit Rampal 12,573 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Ashraf, Have you checked this thread. Hope it helps.

community.dynamics.com/.../reset-selection-from-syslookupmultiselectctrl-when-create-new-record-in-from-data-source
Ashraf_ahk 75 on at

Like (0)

Report
Copy link

Link copied!

Yes I have tried but did not work.
Suggested answer

Vignesh.A 203 on at

Like (0)

Report
Copy link

Link copied!

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

dax365.blogspot.com/.../multi-select-lookup-in-d365-fo.html
Ashraf_ahk 75 on at

Like (0)

Report
Copy link

Link copied!
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); }