Multiselect lookup data is not updating

(0) Share

Report

Posted on by Ashraf_ahk

I have added multiselect 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 (2)

Answers (0)

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); }
Guruprasanna 1,054 on at

Like (0)

Report

RE: Multiselect lookup data is not updating

When you select the new record try to refresh the data source. like dataSource_DS.refresh(); this might help you.

Regards

Guru