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: https://ax.help.dynamics.com/en/wiki/filtering-in-dynamics-ax-7/

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!

37 comments:

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

    ReplyDelete
    Replies
    1. IEEE Final Year Project centers make amazing deep learning final year projects ideas for final year students Final Year Projects for CSE to training and develop their deep learning experience and talents.

      IEEE Final Year projects Project Centers in India are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation.

      corporate training in chennai corporate training in chennai

      corporate training companies in india corporate training companies in india

      corporate training companies in chennai corporate training companies in chennai

      I have read your blog its very attractive and impressive. I like it your blog. Digital Marketing Company in Chennai Project Centers in Chennai

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

    ReplyDelete
  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

    ReplyDelete
    Replies
    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...

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

    ReplyDelete
  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.
    Cheers!

    ReplyDelete
  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

    ReplyDelete
  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.


    ReplyDelete
  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

    ReplyDelete
  9. This comment has been removed by the author.

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

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

    ReplyDelete
  12. Great blog thanks for sharing Leaders in the branding business - Adhuntt Media is now creating a buzz among marketing circles in Chennai. Global standard content creation, SEO and Web Development are the pillars of our brand building tactics. Through smart strategies and customer analysis, we can find the perfect audience following for you right now through Facebook and Instagram marketing. Click here 360 your brand journey Adhuntt Media.
    digital marketing company in chennai

    ReplyDelete
  13. Nice blog thanks for sharing Tidy up your ambience by decorating them with amazing landscape plants in Chennai. Karuna Nursery Gardens is your portal to all the green that the world has to offer. Revolutionize your indoors, garden, terrace or office right now with us.
    plant nursery in chennai

    ReplyDelete
  14. Excellent blog thanks for sharing Setting up a successful salon means that you need the best wholesale cosmetics suppliers in Chennai to back up your brand. With hundreds of exclusive international brands and down to earth service, Pixies Beauty Shop is your destination to success.
    beauty Shop in Chennai

    ReplyDelete
  15. Very useful blog thanks for sharing IndPac India the German technology Packaging and sealing machines in India is the leading manufacturer and exporter of Packing Machines in India.

    ReplyDelete
  16. Great post and informative blog.it was awesome to read, thanks for sharing this great content to my vision. oracle training in chennai

    ReplyDelete
  17. Very nice article excellent information thanks for share.Keep updating thanks
    GRE classes chennai

    ReplyDelete
  18. I am glad to post a worthy article about the German Language Course and IELTS Coaching from KCR consultants, this may change your career growth and language skill.
    KCR CONSULTANTS
    KCR CONSULTANTS

    ReplyDelete
  19. wonderful article contains lot of valuable information. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article.
    This article resolved my all queries.good luck an best wishes to the team members.continue posting.learn digital marketing use these following link
    Digital Marketing Course in Chennai

    ReplyDelete
  20. If Oracle is your dream job, then we, Infycle, are with you to make your dream into reality. Infycle Technologies offers the best Oracle Training in Chennai, which offers various programs in Oracle such as Oracle PLSQL, Oracle DBA, etc., in the 200% hands-on practical training with specialized trainers in the field. Also, the mock interviews will be arranged for the candidates to face the interviews without any fear, and 100% placement assurance will be given here. To have the words above real, call 7502633633 to Infycle Technologies and grab a free demo to know more.Best Oracle Training Institute in Chennai

    ReplyDelete
  21. Very informative blog! I am glad that I came across your article. I'm learning a lot from here. Keep us updated by sharing more such blogs.
    AWS Course in Chennai
    AWS Online Course
    AWS Course in Coimbatore

    ReplyDelete
  22. Infycle Technologies, the No.1 software training institute in Chennai offers the best Oracle course in Chennai for tech professionals and students at the best offers. In addition to the Oracle training, other in-demand courses such as Python, Selenium, Big Data, Java, Python, Power BI, Digital Marketing will be trained with 100% practical classes. After the completion of training, the trainees will be sent for placement interviews in the top MNC's. Call 7504633633 to get more info and a free demo.Best Oracle Course in Chennai | Infycle Technologies

    ReplyDelete
  23. Infycle Technologies, one of the best software training institutes in Chennai offers excellent Oracle PLSQL training in Chennai for freshers and students, and Tech Professionals of any field. Other demanding courses such as Java, Hadoop, Selenium, Big Data, Android, and iOS Development will also be trained with complete hands-on training. After the completion of training, the students will be sent for placement interviews in the core MNC's. Dial 7504633633 to get more info and a free demo.Excellent Oracle PLSQL Training Chennai | Infycle Technologies

    ReplyDelete
  24. Infycle Technologies, the top software training institute and placement center in Chennai offers the No.1 Digital Marketing course in Chennai for freshers, students, and tech professionals at the best offers. In addition to Digital Marketing, other in-demand courses such as DevOps, Data Science, Python, Selenium, Big Data, Java, Power BI, Oracle will also be trained with 200% practical classes. After the completion of training, the trainees will be sent for placement interviews in the top MNC's. Call 7504633633 to get more info and a free demo.

    ReplyDelete
  25. This post is so interactive and informative.keep update more information...
    PHP Training in Bangalore
    php classes in pune


    ReplyDelete
  26. Great Post!!! thanks for sharing this information with us.
    what is .net development
    dot net technology

    ReplyDelete
  27. I cant getting serious on focusing long agreeable to investigate; parts less make this bronzed out of article. Youve eclipsed your self as quick as this material truely. it's miles conceivably of the best blissful. Wifi Hacking Online

    ReplyDelete
  28. i'm unequipped for examining articles online particularly as frequently as could be expected, yet Im delighted I did nowadays. it is picked capability made, and your centers are capably conveyed. I demand you agreeably, connect with, dont anytime lower creating.! Grammarly Crack

    ReplyDelete
  29. Funny Cousin Quotes · Your cousin is the brother God knew your mother could not handle. · The craziness of your family is best understood by your cousins.. Frequently, Cousins Get Together Quotes

    ReplyDelete