Dynamics Community Forum Thread Details

Form Data Source Field Lookup Method Override in D365FO using COC Extension

Hi Experts,

I want to override Form Data Source Field Lookup Method using COC instead of event handlers because user can manually edit field by add column option.

Any one guide me what is wrong here in my code. Debugger does not hit on lookup.

[ExtensionOf(formDataFieldStr(SalesTable, SalesLine, TaxGroup))]
final class SalesTableForm_Extension
{
    public void lookup(FormControl _formControl, str _filterStr)
    {
        Query                           query = new Query();
        QueryBuildDataSource            qbds;
        SysTableLookup                  sysTablelookup;

        next lookup(_formControl, _filterStr);

        sysTablelookup = SysTableLookup::newParameters(tableNum(TaxGroupHeading), _formControl);

        // Filter lookup to only show sales tax Groups
        query.addDataSource(tableNum(TaxGroupHeading)).addRange(fieldNum(TaxGroupHeading, IsSales)).value(queryValue(NoYes::Yes));

        // Sort the lookup by TaxGroup
        query.dataSourceTable(tableNum(TaxGroupHeading)).addOrderByField(fieldNum(TaxGroupHeading, TaxGroup), SortOrder::Ascending);

        sysTablelookup.parmQuery(query);

        sysTablelookup.addLookupfield(fieldNum(TaxGroupHeading, TaxGroup));
        sysTablelookup.addLookupfield(fieldNum(TaxGroupHeading, TaxGroupName));

        sysTablelookup.performFormLookup();

       
    }

}

Quick Links