Monday, 15 July 2019

OnLookup D365

class INTC_JournalNameLookup_EventHandler
{
    [FormControlEventHandler(formControlStr(ProjParameters, ProjParameters_INTC_JournalName), FormControlEventType::Lookup)]
    public static void ProjParameters_INTC_JournalName_OnLookup(FormControl sender, FormControlEventArgs e)
    {
        FormRun                     element = sender.formRun();
        SysTableLookup              sysTableLookup  = SysTableLookup::newParameters(tableNum(LedgerJournalName),sender);
        Query                       query;
        QueryBuildDataSource        qbds;

        sysTableLookup.addLookupfield(fieldnum(LedgerJournalName,JournalName),true);
        sysTableLookup.addLookupfield(fieldnum(LedgerJournalName,Name));

        query = new Query();
        qbds  = query.addDataSource(tableNum(LedgerJournalName));

        sysTableLookup.parmQuery(query);
        sysTableLookup.parmUseLookupValue(true);
        sysTableLookup.performFormLookup();

        FormControlCancelableSuperEventArgs ce = e as FormControlCancelableSuperEventArgs;
        ce.CancelSuperCall();
    }

}

No comments:

Post a Comment