/community/b/english/posts/an-introduction-to-query-builder-and-tree-grid-viewTwo powerful solutions were introduced into the Aras Platform in 11.0 SP10: Query Builder (QB) and Tree Grid View (TGV). QB is a tool for building powerful, reusable AML queries using a graphical user interface. TGV displays the results of one of theja-JPTelligent Community 12https://www.aras.com/community/b/english/posts/an-introduction-to-query-builder-and-tree-grid-viewWed, 30 May 2018 10:42:26 GMT916d3f7e-8ddc-42f8-8d45-380822f51406:5aa2fb6f-4e35-4b92-9ce3-c5b83778e631AngelaIp0Hi Chris, thanks for testing! Sounds great, that opens up many possibilities!<img src="https://www.aras.com/community/aggbug?PostID=957&AppID=4&AppType=Weblog&ContentType=0" width="1" height="1">https://www.aras.com/community/b/english/posts/an-introduction-to-query-builder-and-tree-grid-viewWed, 30 May 2018 09:56:10 GMT916d3f7e-8ddc-42f8-8d45-380822f51406:5aa2fb6f-4e35-4b92-9ce3-c5b83778e631Christopher Gillis0Hi Angela, I just ran a quick test to confirm, and yes, Query Definitions support queries against Federated ItemTypes. Chris<img src="https://www.aras.com/community/aggbug?PostID=957&AppID=4&AppType=Weblog&ContentType=0" width="1" height="1">https://www.aras.com/community/b/english/posts/an-introduction-to-query-builder-and-tree-grid-viewWed, 30 May 2018 09:45:10 GMT916d3f7e-8ddc-42f8-8d45-380822f51406:5aa2fb6f-4e35-4b92-9ce3-c5b83778e631AngelaIp0Will the tree grid view also work for Federated ItemTypes? I have an idea for displaying full or mixed federated data from other system (like ERP) in Tree Grid style. Also I haven´t tried it by myself yet. As far as I see, AML has no trouble to access Federated Data. But maybe there is something to consider?<img src="https://www.aras.com/community/aggbug?PostID=957&AppID=4&AppType=Weblog&ContentType=0" width="1" height="1">https://www.aras.com/community/b/english/posts/an-introduction-to-query-builder-and-tree-grid-viewMon, 30 Apr 2018 08:41:18 GMT916d3f7e-8ddc-42f8-8d45-380822f51406:5aa2fb6f-4e35-4b92-9ce3-c5b83778e631Former Member0It would also be worth mentioning that with versionable item types (like Part), the query builder does not restrict the results set to is_current = 1 records like AML does by default. Therefore, you need to add a condition for is_current = 1 to your query builder definition yourself. If you don&#39;t, you will see all generations of every part.<img src="https://www.aras.com/community/aggbug?PostID=957&AppID=4&AppType=Weblog&ContentType=0" width="1" height="1">