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 × +

5 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
  2. My name is Clara I am here to make a review about how Dr Charles helped me in fixing my marriage and also to those out there seeking for help and advice on how to save your broken marriage or relationship, few months ago I was having issues with my husband I noticed he has been having an affair with another young lady in his place of work I confronted him but he got angry and say to my face that it’s true, as if that was not enough he went ahead by telling me he doesn’t love me anymore that he wanted a divorce I was to devastated and confused, I pleaded with him that I don’t want a divorce but he insisted,before then I had heard about Dr Charles while browsing on the internet how he use to help people with broken marriages and relationships, I gave it a thought and I decided to contact him, he promise to put a smile on my face again, I followed his instructions and after 3days I was so surprised to see my husband kneeling before me and apologizing for what he had said about the divorce, this is something I never expected, I thank Dr Charle for what he has done for me, now am living happily with my husband and he has stopped seeing the other woman. Please if you are having issues like this I advice you to contact Dr Charles he can help you as well drcharlesspeltemple@gmail.com website: https://drcharlesspeltempl.wixsite.com/info WhatsApp: +2348146708557

    ReplyDelete
  3. My name is Clara I am here to make a review about how Dr Charles helped me in fixing my marriage and also to those out there seeking for help and advice on how to save your broken marriage or relationship, few months ago I was having issues with my husband I noticed he has been having an affair with another young lady in his place of work I confronted him but he got angry and say to my face that it’s true, as if that was not enough he went ahead by telling me he doesn’t love me anymore that he wanted a divorce I was to devastated and confused, I pleaded with him that I don’t want a divorce but he insisted,before then I had heard about Dr Charles while browsing on the internet how he use to help people with broken marriages and relationships, I gave it a thought and I decided to contact him, he promise to put a smile on my face again, I followed his instructions and after 3days I was so surprised to see my husband kneeling before me and apologizing for what he had said about the divorce, this is something I never expected, I thank Dr Charle for what he has done for me, now am living happily with my husband and he has stopped seeing the other woman. Please if you are having issues like this I advice you to contact Dr Charles he can help you as well drcharlesspeltemple@gmail.com website: https://drcharlesspeltempl.wixsite.com/info WhatsApp: +2348146708557

    ReplyDelete
  4. My name is Clara I am here to make a review about how Dr Charles helped me in fixing my marriage and also to those out there seeking for help and advice on how to save your broken marriage or relationship, few months ago I was having issues with my husband I noticed he has been having an affair with another young lady in his place of work I confronted him but he got angry and say to my face that it’s true, as if that was not enough he went ahead by telling me he doesn’t love me anymore that he wanted a divorce I was to devastated and confused, I pleaded with him that I don’t want a divorce but he insisted,before then I had heard about Dr Charles while browsing on the internet how he use to help people with broken marriages and relationships, I gave it a thought and I decided to contact him, he promise to put a smile on my face again, I followed his instructions and after 3days I was so surprised to see my husband kneeling before me and apologizing for what he had said about the divorce, this is something I never expected, I thank Dr Charle for what he has done for me, now am living happily with my husband and he has stopped seeing the other woman. Please if you are having issues like this I advice you to contact Dr Charles he can help you as well drcharlesspeltemple@gmail.com website: https://drcharlesspeltempl.wixsite.com/info WhatsApp: +2348146708557

    ReplyDelete
  5. My Dear friends online, My name is sander And i live in USA, New York, I have to give this miraculous testimony, which is so unbelievable until now. I had a problem with my Ex husband 2 years ago, which lead to our break up. I was not myself again, i felt so empty inside me, my love and financial situation became worst, until a close friend of mine told me about a spell caster who helped her in the same problem too his name is Dr KADUKA, I email the spell caster and i told him my problem and i did what he asked of me, to cut the long story short. Before i knew what was happening,in less than two days my husband gave me a call and told me that he was coming back to me i was so happy to have him back to me. The most interesting part of the story is that am pregnant. Thanks to Dr KADUKA for saving my marriage and for also saving others own too. Continue your good work, If you are interested to contact the great spell caster email address: kadukatemple@gmail.com or contact him on whatsApp +393511406759

    ReplyDelete