Lets take this example. We have below hierarchy of entities.
Out requirement is to create a view of Sub Depots where Account Category = Distribution and you need to show both Sub Depots against the Account Name.
Lets try this in Dataverse OOB capabilities.
Though you can easily set the criteria, you will not be able to show the Account name since Account entity is 3 hops away as per the given hierarchy of entities. You are only able to show just two levels. In this case, Sub Depots and Depots.
Lets try Fetch Xml Builder of Xrm Tool Box.
And Results showing without any issue.
Now we will try our next step of transferring this same Fetch to Dataverse.
Now select Save View as option;
Then you get below option to select if you need a personal or system view.
Then you are allowed to give a name to the new view.
View is now created.
Lets try the view now in Dataverse. When you check the fields you will see Dataverse is throwing a error saying these Account fields to be removed,
If you try to run as it is, it will through below error message.
Conclusion
NO!
You cannot use Fetch Xml Builder to create Views in Dataverse that extends the limitations.
No comments:
Post a Comment