Friday, January 20, 2017

Dynamics 365 for Operations Filtering grid changes from AX 2012

Those who have used Dynamics AX for years may be experts in the ways to filter data via a grid and export to excel for ad hoc reporting. Its a significant value add process which many cannot live without. Then you jump to Dynamics 365 for Operations and its likely blank stares when it comes to filtering...

The client experience has changed dramatically from AX 2012 to Dynamics 365 for Operations (use #D3FO on twitter for this name). From a 32-bit desktop client to embedded web client. That transition required form controls to change and thus how filtering occurs.

So the ultimate question: How do you filter grids in Dynamics 365 for Operations?

Refer to the following documentation for these changes:

This documentation is fluid so please check it out for the latest information. The below is reposted and summarized for point in time reference and quick reference (for me).

Here are the operations for using a the Filter Operator vs the AX Query Syntax method (e.g. "advanced query" or "Crtl+G on grid and 'X..Z'").

Figure 1 - Filter expressions 'Filter Operator' vs 'Dynamics AX query syntax'

Its very important to note that '*' will literally look for an asterisk in the name. So you don't need that. The commands are more literal and in a natural language rather than syntax. It may seem to take longer to adapt but you'll adapt quicker than you think if you go into it with an open mind.

Hopefully that helps!


  1. This comment has been removed by a blog administrator.

  2. This comment has been removed by a blog administrator.

  3. Usually I do not read post on blogs, but I would like to say that this write-up very forced me to try and do it! Your writing style has been surprised me. Great work admin.Keep update more blog.
    Cat Coaching in Chennai

    1. 'Cat' is a acronym and should be 'CAT. I'm leaving this ad on here because the spam turned the 'Common Admissions Test' to a cuddly little beast with razors on its feet. 'CAT Coaching in Chennai – Ultimate Gateway for your Dream Career'. I've never wanted anything more than to just train cats all day. DAX Dude - The Cat Whisperer...

  4. This comment has been removed by a blog administrator.

  5. Thank you for this one. I found this website really interesting and useful for beginners. I have recently introduced Microsoft Dynamics AX in my company and I still feel that I need to learn a lot.

  6. Hello friends! I had problems with installation the silent mode Microsoft Dynamics AX, your blog help me! thank you that you wrote about procedure to Create a Group Policy Logon Script and details steps. It's not so hard how I'm thinking ;) microsoft 365 pricing

  7. Nice blogpost and thanks for sharing such useful information about Microsoft Dynamics. If you are looking for Microsoft Dynamics AX solution then you should visit atDynamics AX Partner Australia. DFSM Consulting has Microsoft Dynamics AX support, upgrade & implementation solutions for your business needs.

  8. Its a wonderful post and very helpful, thanks for all this information. You are including better information regarding this topic in an effective way.Thank you so much

    Digital Marketing Company in India
    Web Development Company in India
    Web Design Company in Chennai
    Android app development company in Chennai

  9. Very well done. Absolutely brilliant information. I'm in love with this blog. they always provide such a great information. Dynamics AX Partner Australia