[Mark Jones]

I could not find a report that shows customer pools and their criteria in Dynamics AX 2012 R3.  I went to first create a sQL query before creating my own report but it would seem as though the field that creates the criteria lives in CustCollectionsPool.QueryPacked.

How do you extract that data in a SQL query so you can display the actual criteria used to query the customers in each pool?

The only workaround I found was to click on each pool in each company, Ctrl+T to Excel, and then copy and paste.  This represented 53 different pools across 13 companies, and 128 total criteria across those pools.  Not desirable.

Thank you.

——————————
Mark Jones
Lead IT Business Analyst
Unigroup
Fenton MO
——————————

[Robert Shannon]

You could use the functions found in the second part of this article:

Displaying and Saving a Query

Dynamicsax-dev		remove preview
Displaying and Saving a Query Sometimes it might be useful to display a query you have created in the AOT to the user. After this the user makes changes to the query (adds ranges and sort fields) and you would like to save the query (as changed by the user) to a table in the database, therefore saving the state of the query as modified by the user. View this on Dynamicsax-dev >

From there, you should be able to get to the queryBuildDataSource, and output that through info, along with any other items you needed.

Just a thought on how to proceed at least.

Edit to add:

this should work for you. Used the above information to compose:

Tested on some data, and output the info of the query used.

——————————
Robert Shannon
ERP Analyst
Leatherman Tool Group
Portland OR
——————————
——————————————-