latest Post

Dynamics365 Custom FetchXML Sub Grids (Classic UI)

Recently we had a requirement to show Order information in a sub grid on the account page. Where this differed from a standard request was the customer wanted to show all Orders relating to the customer regardless of the association. For example, we  have multiple look ups to the account record on the Order entity for the various different parties for example Sold To, Ship To, Bill To and End User. 

To achieve this I dynamically generated a fetchXML query filtering the data based on the the id of the current record. Then using the "SetParameter" method injected the sub grid with the dynamics fetch XML  query. (see below). 

Update:  
It appears this does not work with the new Unified Interface as this stopped working during the upgrade but does work if I revert back to classic UI. Strange as I did think this was a supported method as I did not directly reference any DOM elements but it appears calling "SetParameter" was never supported. I have seen a workaround  here which talks about  overriding"Microsoft.Crm.Client .Core.Storage.DataApi.ListQuery .prototype.set_FetchXml" function. However, I prefer to use supported methods therefore I will look at achieving the same functionality using the Retrieve multiple plugin method instead. It does seem to be overkill though and I would expect Microsoft to have provided some supported function in which we could  easily inject FetchXML or Odata into a page using client side functionality.
Recommended Posts × +

1 comments:

  1. I promise to share this testimony all over the world once my boyfriend returns back to me, and today with all due respect I want to thank DR.ONIHA for bringing joy and happiness to my relationship and my family. I want to inform you all that there is a spell caster that is real and genuine. I never believed in any of these things until I lost my boyfriend, I required help until I found a great spell caster, And he cast a love spell for me, and he assured me that I will get my boyfriend back in two days after the spell has been cast. Three days later, my phone rang, and so shockingly, it was my boyfriend who has not called me for the past 6 years now, and made an apology for the heart break, and told me that he is ready to be my backbone till the rest of his life with me. DR.ONIHA released him to know how much I loved and wanted him. And opened his eyes to picture how much we have shared together. As I`m writing this testimony right now I`m the happiest girl on earth and me and my boyfriend are living a happy life and our love is now stronger than how it was even before our break up. So that`s why I promised to share my testimony all over the universe. All thanks goes to DR.ONIHA for the excessive work that he has done for me. Below is the email address in any situation you are undergoing, it may be a heart break, and I assure you that as he has done mine for me, he will definitely help you too.
    EMAIL: ONIHASPELLTEMPLE@GMAIL.COM
    CALL/WHATSAPP : +16692213962.
    Website: http://onihaspells.com. 

    ReplyDelete