In Hub, how to filter subgrid, using JavaScript or Plugin

(0) Share

Report

Posted on by Zhenyu Wang

Hi All,

The fetchxml I need is with linked entity and with 'under' condition.

'<link-entity name="account" from="accountid" to="customerid" link-type="inner" alias="bm">' +
'<filter type="and">' +
'<condition attribute="accountid" operator="under" uitype="account" value="{' + accountId + '}" />' +
'</filter>' +
'</link-entity>'

The JavaScript and Plugin both are working in traditional Dynamics 365, but NOT in HUB.
Let me tell you, what I have tried.

JavaScript, I tried these to set and refresh:
formContext.getControl("subgridname").getGrid().setParameter("fetchXml", fetchXml);
parent.Xrm.Page.getControl("subgridname").setFilterXml(fetchXml)
window.parent.document.getElementById("subgridname"); -> cannot find 'control' using this one.

plugin, I tried on 'RetrieveMultiple' event and replace context.InputParameters["Query"]

With either JavaScript or Plugin,
As the subgrid shows correct result in traditional Dynamics 365, could I think, this is another defect in Hub?

If anyone has working examples in HUB, could you peleas share?

Thank you very much in advance.

Regards,

Zhenyu

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

CRM Develope 894 on at

Like (0)

Report

Hello,

Please check below link:

nishantrana.me/.../plugin-on-retrieve-multiple-in-crm-2015

Thank you

Was this reply helpful? Yes No
Zhenyu Wang on at

Like (0)

Report

Hi CRM Develope,

Thank you for reply.

However, did you ever read my questions...
I already tried this plugin on 'RetrieveMultiple'. My issue is working in traditional Dynamics 365, but no in HUB

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

Hi,

Please check below old thread -

community.dynamics.com/.../299697

Was this reply helpful? Yes No
Zhenyu Wang on at

Like (0)

Report

Hi Goutam,

I have tried to inject the fetchxml into ListQuery.

I do see the fetchxml is updated.

However even I manually refresh the subgrid, nothing changed.

Was this reply helpful? Yes No
MMK 745 on at

Like (0)

Report

Hi

Did you find any solution

Was this reply helpful? Yes No
Suggested answer

MMK 745 on at

Like (0)

Report

Hi All

here I have solution that works for both UCI and Classic

mkdynamicsunfied.blogspot.com/.../filter-subgrid-in-dynamics-unified-hub.html

Was this reply helpful? Yes No
rthompson 1,532 on at

Like (0)

Report
Hi Moin,

Not much information on how to get the UCI filter on subgrid to work.

I found your link mkdynamicsunfied.blogspot.com/.../filter-subgrid-in-dynamics-unified-hub.html but I am getting a error message.

I have a question.

When filtering is the existing view condition being replace or do I need to also add the attributes that will need to appear in the grid.

FetchXml

var fetchXml = "" "" // "" // "" // "" // "" // "" // "" // "" // "" // "" // "" // "" // "" // "" // "" // "" // "" // "" "" "" "" "" "" "";

Was this reply helpful? Yes No
rthompson 1,532 on at

Like (0)

Report
This link works great.

mkdynamicsunfied.blogspot.com/.../filter-subgrid-in-dynamics-unified-hub.html

I had to change my condition uinname and value around.

"" ""

Was this reply helpful? Yes No
RHOU 65 on at

Like (0)

Report

I just created a very detailed feature wish to make this happen in a supported way for Unified Interface here:

PLEASE VOTE!

powerusers.microsoft.com/.../675538

Was this reply helpful? Yes No