Showing more than one value in same Brand name in my Dialog using UI Builder Class

Finance and Operations/AX Developer Forum
1

Hi guys.

I create UI Builder class to have a Brand name Parameter…

it shows like this…

dddd.jpg

here’s my UI Builder code:

public class MYUIBuilder extends SrsReportDataContractUIBuilder
{
    PSTDataContract             datacontract;
    
}


public void build()
{
    DialogGroup dlgGrp;

    //get the current dialog
    Dialog      dlg = this.dialog();

    datacontract = this.dataContractObject();

    //associate dialog field with data contract method
    this.addDialogField(methodStr(PSTDataContract,parmFromDate), datacontract);
    this.addDialogField(methodStr(PSTDataContract,parmTodate), datacontract);
    this.addDialogField(methodStr(PSTDataContract,parmCategory), datacontract);
    this.addDialogField(methodStr(PSTDataContract,parmvalue), datacontract);
}


public void lookupTextValue(FormStringControl _formStringControl)
{
    Query query = new Query();
    QueryBuildDataSource DS;
    SysTableLookup sysTablelookup;

    //create a table lookup
    sysTablelookup = SysTableLookup::newParameters(tableNum(EcoResTextValue),_formStringControl);
    sysTablelookup.addLookupfield(fieldNum(EcoResTextValue,TextValue));
    
    //create a query
    DS = query.addDataSource(tableNum(EcoResTextValue));
    DS.addRange(fieldNum(EcoResTextValue, TextValue));
    
    
    //assign the query and call lookup
    sysTablelookup.parmQuery(query);
    sysTablelookup.performFormLookup();
}

public void postBuild()
{
    DialogField dlgCustGroup;

    super();

    dlgCustGroup = this.bindInfo().getDialogField(this.dataContractObject(),
                methodStr(PSTDataContract,parmvalue));

    //register the method we want to override
    dlgCustGroup.registerOverrideMethod(
          methodStr(FormStringControl, lookup),
          methodStr(MYUIBuilder,lookupTextValue),
          this);
}

when i select brand, my report running fine and it filter the correct value.

Little help here guys !

TIA

2

I solve my problem…

using this code.

qbds = query.addDataSource(tableNum(EcoResTextValue));
qbds.addSortField(fieldnum(EcoResTextValue, TextValue));
qbds.addOrderByField(fieldnum(EcoResTextValue, TextValue));
SysTableLookup.parmUseLookupValue(false);
qbds.orderMode(OrderMode::GroupBy);