Dynamics 365: Unified Interface: Inject FetchXml into Subgrid

(0) Share

Report

Posted on by Community Member

Hello,

We have a sub-grid on the entity's form and the data of this sub-grid depends on some field's value.

To accomplish this we use

grid.control.SetParameter('fetchXml', query);

where

grid is an HTML element of the sub-grid on the entity's form

query is a string which contains a fetch xml query with our field's value.

I know that it is an unsupported way and it works for Dynamics 365 CRM with classic UI but it doesn't work in the v.9 unified interface.

I have spent some time debugging internal CRM scripts and found out that there is a Microsoft.Crm.Client.Core.Storage.DataApi.ListQuery object. And I can call it's "set_FetchXml" function to inject my own fetch xml query into this grid. And it works. But I didn't find a way how to get this object from a sub-grid HTML element.

If anyone did research how to do it, please advise.

Thanks in advance.

*This post is locked for comments

All responses (37)

Answers (1)

RHOU 65 on at

Like (0)

Report

RE: Dynamics 365: Unified Interface: Inject FetchXml into Subgrid

I just created a very detailed feature wish to make this happen here:

PLEASE VOTE!

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Binding-FetchXML-to-Subgrid-with-reference-to-RecordID-to-filter/idi-p/675538
Suggested answer

Daryl LaBar 500 Most Valuable Professional on at

Like (0)

Report

RE: Dynamics 365: Unified Interface: Inject FetchXml into Subgrid

I've blogged my solution to this here: dotnetdust.blogspot.com/.../setting-sub-grid-filterxml-in-unified.html

The code is still unsupported, but feels much more safe than anything I've seen here.
Community Member on at

Like (0)

Report

RE: Dynamics 365: Unified Interface: Inject FetchXml into Subgrid

Hi, Peter! We have a very similar requirement and would like to avoid creating additional relationships and mapping the key to a linked tables.

Were you able to find a suitable solution?

We'd appreciate any insight you might have =)

Thanks,

Leo
Suggested answer

MMK 745 on at

Like (0)

Report

RE: Dynamics 365: Unified Interface: Inject FetchXml into Subgrid

Hi All

here I have solution that works for both UCI and Classic

mkdynamicsunfied.blogspot.com/.../filter-subgrid-in-dynamics-unified-hub.html
Community Member on at

Like (0)

Report

RE: Dynamics 365: Unified Interface: Inject FetchXml into Subgrid

@blackF That has been removed from Microsoft, For what you need that?
blackF 5 on at

Like (0)

Report

RE: Dynamics 365: Unified Interface: Inject FetchXml into Subgrid

Hi ,

In the UCI window Microsoft.Crm.Client.Core didn't contains Storage only Framework see below.

please help!

thanks
Community Member on at

Like (0)

Report

RE: Dynamics 365: Unified Interface: Inject FetchXml into Subgrid

Hey I have the solution of your Query. I worked on this and was able to find the solution in a supported way. The solution alos includes lined entity. Please go through my WordPress blog link. Please mark my answer if you find this helpful.

sank8sinha.wordpress.com/.../
Community Member on at

Like (0)

Report

RE: Dynamics 365: Unified Interface: Inject FetchXml into Subgrid

Hey I have the solution of your Query. I worked on this and was able to find the solution in a supported way. The solution alos includes lined entity. Please go through my WordPress blog link. Please mark my answer if you find this helpful.

https://sank8sinha.wordpress.com/2020/01/07/adding-filtered-views-in-uci-in-dynamics-365-crm-finally-achieved/
Peter Bjorkmarker 10 on at

Like (0)

Report

RE: Dynamics 365: Unified Interface: Inject FetchXml into Subgrid

Thanks for the response!

My need was to use to for link entities a few levels deep and filter on the current record. Understand that scenario does not work for you either.

Agreed, unsupported is a pain and can get broken anytime by an update. You can of course build your own grid from scratch and use a web resource but a fair mount of work.

Peter Björkmarker
JanpKentico 20 on at

Like (0)

Report
RE: Dynamics 365: Unified Interface: Inject FetchXml into Subgrid

Hi Peter,

I am not using gridControl.getFetchXml() method - it also returns null for me, but as far as I am not using this method I don't care.

Example of how I inject the custom fetch into my opportunity grid in the Account form.

Having account form with opportunity grid (show all opportunities) - grid Name 'TestOpportunity'

in the account form properties, I have registered my javascript e.g. account.js with OnLoad method which is injecting the fetch into opportunity grid

the account.js contains:

function OnLoad(executionContext) { var formContext = executionContext.getFormContext(); var accountId = formContext.data.entity.getId(); var opportunitySubgrid = formContext.getControl("TestOpportunity"); var opportunityFetchXml = "" "" "" "" "" "" "" ""; opportunitySubgrid._gridControl.setFilterXml(opportunityFetchXml); opportunitySubgrid._gridControl.refresh(); }

Does not matter whether the grid is somewhere in a separated account form tab.

But I have found this injection has few limitations

seems it works only for "simple" fetchXml, but does not work when the fetch contains:

hierarchical operator='eq-or-under' - throws exception for me

link entity - cannot work with entity aliases

TOP=X record attribute is ignored

I hope that one day we will be able to apply custom fetch in some supported way:)

Best regards,

Jan

: