alirazazaidi: Custom lookup UIBuilder SSRS RDP Dynamics 365 for finance and operations

[Blog bot]

Источник: https://www.tech.alirazazaidi.com/cu...nd-operations/
==============

Hi, Today I have simple code snippet to create a custom lookup in SSRS Reports in Dynamics 365 for finance and operations.

public class MyUIBuilder extends SrsReportDataContractUIBuilder{    private DialogField vendordf,dialogbranch;        MyDC     contract;    public void postBuild()    {        super();        contract = this.dataContractObject();        // binding dialogs with contract fields        vendordf = this.bindInfo().getDialogField(this.dataContractObject(),            methodStr(MyDC, parmHcmPerfPeriodId));        dialogbranch = this.bindInfo().getDialogField(this.dataContractObject(),            methodStr(MyDC, parmOMOperatingUnitNumber));       dialogbranch.registerOverrideMethod(methodStr(FormStringControl,lookup),methodStr(BEHCMReviewUIBuilder,divisionCodeLookup),this);          vendordf.registerOverrideMethod(methodStr(FormStringControl,lookup),methodStr(BEHCMReviewUIBuilder,PerfPeriodIdLookup),this);           }    public void postRun()    {        }     private void PerfPeriodIdLookup(FormStringControl divisionCodeLookup)    {        Query                   query = new Query();        QueryBuildDataSource    qbd, qbdPerson;            QueryBuildDataSource qbds;        QueryBuildDataSource qbdsJoin;        SysTableLookup sysTableLookup = sysTableLookup::newParameters(tableNum(HcmPerfPeriod), divisionCodeLookup);        qbds= query.addDataSource(tableNum(HcmPerfPeriod));          sysTableLookup.parmQuery(query);           sysTableLookup.addLookupfield(fieldNum(HcmPerfPeriod, PerfPeriodId), true);             sysTableLookup.parmQuery(query);        sysTableLookup.parmUseLookupValue(False);        sysTableLookup.performFormLookup();    }    private void divisionCodeLookup(FormStringControl divisionCodeLookup)    {        Query          query;        QueryBuildDataSource  qbds,qbds1;        SysTableLookup     sysTableLookup;        DimensionAttribute   dimAttr;        ;        sysTableLookup = SysTableLookup::newParameters(tablenum(OMOperatingUnit),divisionCodeLookup);        sysTableLookup.addLookupfield(fieldnum(OMOperatingUnit, OmoperatingunitNumber));        sysTableLookup.addLookupfield(fieldNum(OMOperatingUnit,Name));        query = new Query();        qbds = query.addDataSource(tableNum(OMOperatingUnit));        qbds.addRange(fieldNum(OMOperatingUnit, OMOperatingUnitType)).value(queryvalue(OMOperatingUnitType::OMDepartment));        sysTableLookup.parmQuery(query);        sysTableLookup.parmUseLookupValue(False);        sysTableLookup.performFormLookup();    }}

Источник: https://www.tech.alirazazaidi.com/cu...nd-operations/