Microsoft Dynamics AX (Archived)

Filter data based on the lower level satasource

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (5)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Filter data based on the lower level satasource

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.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Filter data based on the lower level satasource

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
Verified answer

Anton Venter 18,788 Super User 2024 Season 2 on at

Like (1)

Report
RE: Filter data based on the lower level satasource

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));
Suggested answer

Vilmos Kintera 46,149 on at

Like (1)

Report

RE: Filter data based on the lower level satasource

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.
André Arnaud de Cal... 291,391 Super User 2024 Season 2 on at

Like (0)

Report

RE: Filter data based on the lower level satasource

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?