Dear all,
I have the following situation: On the one hand Entity X has a lookup ref to Account (main type) and on the other hand Entity X has connections with Account (support type). Entity X is needed since it hold extra information and synchs with an external system.
What I'd like to achieve is to create a sub-grid (associated view) on the Account form (from main type perspective) which for the references from Entity X shows the connections with Accounts (from support type).
It was easy to create an advanced find query for Connections and get the relevant info but then the Account of Main type is needed as parameter and I somehow would like this parameter to be the account which is loaded on the form. Furthermore, I tried making an advanced find query for Entity X but when I try to add columns to the view, the ones for Record type Connection From/To are not available so I think that I might be hitting some limitation.
My question is if what I try to achieve is actually possible with the what Dynamics provides as out-of-the-box :)
Cheers
Vassil
*This post is locked for comments
Hi Aiden,
We decided to design an extra entity instead of doing the JavaScript trick since we do not get any guarantees if it will work with the next release. And in the comments of the blog post there are quite some reactions regarding the correct syntax.
Regards
Vassil
Hi Vassil,
Did you have any luck with this?
Thanks,
Aiden
Hi Vassil,
Thanks for the clarification. If you're having trouble getting a view to work with a filter for the main account, I know that you can add javascript to set the query on the grid. It's not exactly supported, but it's not invasive either. Here's details on how you'd do that: joshimandarblog.wordpress.com/.../crm-2015-applying-custom-fetchxml-to-a-subgrid-using-javascript
The easiest way to implement that is to build a query in advanced find to get back the records you want for "Account A", then export the FetchXml and put that in your javascript as your query. then all you need to do is replace the "Account A" ID in the query with the ID of the record you're on, and you'll be good to go.
Let me know how it goes. If this helps I'd appreciate if you marked this as Answering your question.
Thanks,
Aiden
This is how the setup looks like:
Basically in the form of Account (Main Type) I would like to have a sub-grid with all Accounts of Support Type.
Hi Aiden,
This is the correct setup. I have just one clarification: the 2 references to Account are actually to different account objects. Otherwise what you have described is exactly what I have also tried myself but this is not yet the solution.
Cheers
Vassil
Hi Vassil,
Quick question - is this your entity setup (arrow is a lookup):
And on the account form, you want a grid of Connections that are related to an Entity X ?
If that's what you're looking for, it's easy to do and a good example is on the opportunity form (Sales Team, Stakeholders, etc), which are showing only some connections. Here's what you want to do:
Here's a screenshot from the Opportunity, yours should be very similar:
Let me know how this goes. If it helps I'd really appreciate if you'd mark this as Answering your question.
Thanks,
Aiden
André Arnaud de Cal...
291,969
Super User 2025 Season 1
Martin Dráb
230,846
Most Valuable Professional
nmaenpaa
101,156