Microsoft Dynamics AX (Archived)

Filter data based on the lower level satasource

(0) Share

Report

Posted on by Community Member

There is any way to Filter Upper data source based on Lower One?

I want to filter data on Grid1 wich contain itemId from InventTable based on BOMQty on G2 from BOM Table

BOM Table is related to InventTable as follows:

6116.Capture.PNG

Code:

queryBuildDataSource = BOM_ds.query().addDataSource(tableNum(BOM));
           queryBuildDataSource = queryBuildDataSource.addDataSource(tableNum(InventTable));
           queryBuildDataSource.relations(true);
           queryBuildDataSource.addLink(fieldNum(InventTable, ItemId), fieldNum(BOM,ItemBOMId));

           QtyQBR = queryBuildDataSource.addRange(fieldnum(BOM,BOMQty));
           QtyQBR.value(queryvalue(SearchStringEdit.text())); // a filter field

           BOM_ds.executeQuery();

when i run it i get the following error: "Les requêtes comptant plusieurs sources de données de niveau supérieur ne peuvent pas être appliquées aux écrans."

Thanks

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Sort by

André Arnaud de Cal... 306,446 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Ennasri,

Please update the question with some more information. Is this is a custom form with use of temporary tables? What is the exact error message in English?

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (1)

Report
Copy link

Link copied!

That would be a circular reference. The changing value of the inner datasource would trigger a refresh on the outer datasource, which then refreshes the inner datasource again so it goes in a loop.

You have to know and apply the filtering criteria up front. Also you are trying to add the same tables again that I assume already exist in your form with addDataSource, which is wrong.

Was this reply helpful? Yes No
Verified answer

Anton Venter 20,946 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi, you are getting this error because it seems you are adding a second BOM datasource the existing BOM datasource. I am assuming you have a BOM datasource. Try to change your first line to:

queryBuildDataSource = BOM_ds.query().dataSourceTable(tableNum(BOM));

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thank you for replying, yes it was an existing BOM Datasource,this fixed the error problem, but i still not able to get result with filter

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Thank you for replying, yes it was an existing BOM Datasource

I didn't understand your note, what is the meaning of " apply the filtering criteria up front"?

Thanks.

Was this reply helpful? Yes No