Microsoft Dynamics AX (Archived)

Custom lookup error

(0) Share

Report

Posted on by John Chircop

160

I am getting the following error with a custom lookup method.

"Failed to execute query because no root data source on the form matches the root datasource on the query"

The main datasource in the form is a temporary table, and the filter I am implementing in the custom lookup uses a separate set of tables, albeit the return type EDT is the same.

Any help appreciated.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Ivan (Vanya) Kashperuk Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Try creating a separate form that shows that data, with the same data source setup.

If that works, you'll just be able to reuse it as your lookup form.

If it doesn't, in the process you should be able to see the wrong of your ways. :)

The above sounds incorrect. The EDT has nothing to do with selecting the data.

Was this reply helpful? Yes No
Steve Kirchner 15 on at

Like (1)

Report
Copy link

Link copied!

This error can occur when the wrong TableId is passed in SysTableLookup::newParameters(). Make sure you use the table you want to do the lookup in (not the table you're doing for).

Was this reply helpful? Yes No
Martina Bergamo 1,470 on at

Like (1)

Report
Copy link

Link copied!

The main datasource of your query must be the same as the main datasource in the form.

If you want to show fields from other tables, you can use this:

sysTableLookup.addLookupMethod(tablemethodstr(tableName, methodName));

where the method is a display method and the table is the same as the main datasource!

I hope it can help you!

Was this reply helpful? Yes No
Suggested answer

smith.matrix 45 on at

Like (0)

Report
Copy link

Link copied!

This makes sense..Thank you

Was this reply helpful? Yes No
Martin Dráb 240,196 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Please mark the helpful reply (replies) as the verified answer.

Was this reply helpful? Yes No
smith.matrix 45 on at

Like (0)

Report
Copy link

Link copied!

"The main datasource of your query must be the same as the main datasource in the form.

If you want to show fields from other tables, you can use this:

sysTableLookup.addLookupMethod(tablemethodstr(tableName, methodName));

where the method is a display method and the table is the same as the main datasource!

I hope it can help you!"

Martina Bergamo

Was this reply helpful? Yes No
Martin Dráb 240,196 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I meant something else. There is a question beside each reply asking "Did this answer your question?" and if you say Yes, it marks the thread as resolved and the reply is listed in the Only Answers view. Nevertheless it's true only if it's your thread; I didn't notice that the question was asked by somebody else than yourself.

Was this reply helpful? Yes No
Sheetal.D 177 on at

Like (0)

Report
Copy link

Link copied!

May i know how the same logic works for sysdatasetlookup?

Was this reply helpful? Yes No