19.10.2012, 02:14 | #1 |
Участник
|
equalized: Dynamics Ax composite queries
Источник: http://www.kevinroos.be/2012/10/dyna...osite-queries/
============== Hi all, Currently I’m working on a new Dynamics Ax 2012 project and for that I’m developing a lot of list pages and forms. For these I had to make multiple menu items that open a list page with different filters, you can do this by setting the menu item query property or calling a class which calls the form with the correct query. So this involves creating a lot of query objects for the same table with only a few extra filters. If only there was a way to inherit queries from each other and there is! It’s called composite queries and it’s only useful when you just want to extend your query with range or overriding a method. Also you can only derive one time from a query. An example: First I’ve created a base query that filters on Sales Type with value Sales Order. So I have a query that filters all regular sales orders. Next I’m creating a new query without any data sources and I drag my base query to the Composite query node. Then I can add my specific range, such as on Sales Status with value back order. That’s it! Now I can create multiple queries such as for delivered or invoiced orders and if I want to apply and extra range for all the queries I only have to change the base query. source: MSDN Источник: http://www.kevinroos.be/2012/10/dyna...osite-queries/
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору. |
|
|
|