Finance | Project Operations, Human Resources, ...

Could not process the lookupRecord value on the Args instance

(1) Share

Report

Posted on by ..

1,965

Hi,

I'm getting this error:

Could not process the lookupRecord value on the Args instance. The table 'Table2' does not exist as a root FormDataSource for the form 'SalesTable__SalesLine_CodeXRecId'

Public class CodeXEventHandlers
{

     FormDataSourceEventHandler(formDataSourceStr(SalesTable, SalesLine), FormDataSourceEventType::Initialized)]
    public static void SalesLine_OnInitialized(FormDataSource sender, FormDataSourceEventArgs e)
    {

            var overrides = SalesTableFormExtensionOverrides::construct();

            sender.object(fieldNum(SalesLine, CodeXRecId)).registerOverrideMethod(methodStr(FormReferenceControl, lookupReference)
            , methodStr(SalesTableFormExtensionOverrides, overridenCodeXRecIdLookup), overrides);

    }

}


public class SalesTableFormExtensionOverrides
{
    protected void new()
    {
    }

    public static SalesTableFormExtensionOverrides construct()
    {
        return new SalesTableFormExtensionOverrides();
    }




    public Common overridenCodeXRecIdLookup(FormReferenceControl _formControl)
    {
        Common                      commonRecord;
        View1                        selectedRecord;

        SysReferenceTableLookup sysTableLookup = SysReferenceTableLookup::newParameters(tableNum(View1), _formControl);
       
        FormRun         formRun         = _formControl.formRun();
        FormDataSource  salesLine_ds    = formRun.dataSource(formDataSourceStr(SalesTable, SalesLine));
        SalesLine       salesLine       = salesLine_ds.cursor();
        Query           query           = new Query();
               
        QueryBuildDataSource qbds = query.addDataSource(tableNum(View1));


        if(salesLine.ItemId)
        {
            qbds.addRange(fieldNum(View1, ProductCodeY)).value(queryValue(salesLine.ItemId));
        }
        if(salesLine.Id)
        {
            qbds.addRange(fieldNum(View1, Id)).value(queryValue(salesLine.bId));
        }

        QueryBuildDataSource inventTableDataSource = qbds.addDataSource(tableNum(InventTable));
        inventTableDataSource.relations(false);
        inventTableDataSource.addLink(fieldNum(View1, CodeY),fieldNum(InventTable, ItemId));
        inventTableDataSource.joinMode(JoinMode::InnerJoin);
        inventTableDataSource.addRange(fieldNum(InventTable, DataAreaId)).value(queryValue(salesLine.DataAreaId));

        sysTableLookup.addLookupfield(fieldNum(View1, CodeY));
        sysTableLookup.addLookupfield(fieldNum(View1, Name));
        sysTableLookup.addLookupfield(fieldNum(View1, Field1));

        sysTableLookup.parmQuery(query);
        commonRecord = sysTableLookup.performFormLookup();
        if (commonRecord.RecId)
        {
            selectedRecord = commonRecord;
        }

        return selectedRecord;

    }

}

Note: View1 has Table2 inner join table1

Existing relations on tables:
Table2.Id == Table1.Id

SalesLine.CodeXRecId == Table2.RecId

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (6)

Answers (0)

Martin Dráb 237,805 Most Valuable Professional on at

Like (0)

Report

I guess that you're returning a wrong table, e.g. that you have a lookup for Table2 and you're returning View1 instead. Use the debugger to see what your code does at runtime.

Was this reply helpful? Yes No
.. 1,965 on at

Like (0)

Report

Hi Martin,

I can't tell what's wrong, when i debug, commonRecord shows "no data selected"

I need the view because i'm showing fields from different tables, not sure what to do instead

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,805 Most Valuable Professional on at

Like (0)

Report

There are surely things you could find out. For example, where is the error thrown from? If performFormLookup() returns a value, what is the data type?

Anyway, if CodeXRecId has a relation to Table2.RecId, you lookup must return Table2. That you're returning View1 instead is a bug and a reason for the error.

Was this reply helpful? Yes No
.. 1,965 on at

Like (0)

Report
Hi Martin,

How i'm going to return Table2? what to amend in my code?
My view contains Table2 joined with Table1. And i need the view, because the field name exists in Table1 and not Table2 and i need to show it in the lookup
sysTableLookup.addLookupfield(fieldNum(View1, Name));

the error appears when calling performFormLookup.
here exactly

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,805 Most Valuable Professional on at

Like (0)

Report

You need Table2. You can, for example, get View1 from performFormLookup(), find the corresponding Table2 record and return it from overridenCodeXRecIdLookup().

Or you could stop using View1, because you're wrong in thinking that there is no solution without a view. You could write a display method on Table2 and add it to the lookup via addLookupMethod().

Was this reply helpful? Yes No
.. 1,965 on at

Like (0)

Report

Hi Martin,

Yes i already solved it by adding the other field as display method.

But if i kept using the view, how would i return table2 from it? you mean do another select to get the table by relating it to the view?

Was this reply helpful? Yes No

Join the conversation

Community site session details

Could not process the lookupRecord value on the Args instance

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Could not process the lookupRecord value on the Args instance

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates