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?

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Mohit Rampal 12,563 Moderator on at

Like (0)

Report

RE: Multiselect lookup data is not updating

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

Was this reply helpful? Yes No
Ashraf_ahk 75 on at

Like (0)

Report

RE: Multiselect lookup data is not updating

Yes I have tried but did not work.

Was this reply helpful? Yes No
Suggested answer

Vignesh.A 203 on at

Like (0)

Report

RE: Multiselect lookup data is not updating

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

Was this reply helpful? Yes No
Ashraf_ahk 75 on at

Like (0)

Report
RE: Multiselect lookup data is not updating

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); }

Was this reply helpful? Yes No

Join the conversation

Community site session details

Multiselect lookup data is not updating

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Multiselect lookup data is not updating

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates