Personalized Community is here!
Quickly customize your community to find the content you seek.
Check out the latest Field Service updates!Learn about the key capabilities and features of Dynamics 365 Field Service and experience some of the new features.
Download overview guide | Watch Field Service video
2021 Release Wave 1Discover the latest updates and new features to Dynamics 365 planned April 2021 through September 2021.
Release overview guides and videos Release Plan | Preview 2021 Release Wave 1 Timeline
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
Hope You are doing well.I have a situation where i have to filter all product inventory by warehouse of logged in user + warehouses of users in his teams as well. Here one user can be in many teams.
My View has an existing warehouse column to filter.I made a query in Fetch XML Builder in which i have to link entities many times like:Product Inventory => warehouse => bookableresource => user=> teammember ship => teams ===> and goes onand also i tried other approaches like Owner equals Current User or User's Teams etc. but it does not work very well.Then i created another separate XML query to get warehouses of logged in user plus warehouses of user in his teams which shows promising results but now, i am not sure how to pass this result data in the main View for filter.Is there any way to filter out data using Parameters in Views ? MAIN System View Fetch-XML Code:
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" >
<entity name="msdyn_productinventory" >
<attribute name="createdon" />
<attribute name="msdyn_warehouse" />
<attribute name="msdyn_unit" />
<attribute name="msdyn_qtyonhand" />
<attribute name="msdyn_product" />
<attribute name="msdyn_reorderpoint" />
<attribute name="msdyn_qtyonorder" />
<attribute name="msdyn_qtyavailable" />
<attribute name="msdyn_qtyallocated" />
<order attribute="msdyn_product" descending="false" />
<link-entity name="product" from="productid" to="msdyn_product" visible="false" link-type="outer" alias="a_a40a32e0381aea11a816000d3a795180" >
<attribute name="description" />
<attribute name="msdyn_productinventoryid" />
My Query to Get WareHouses of Current User and Users in His Team's Warehouses:
<fetch count="5000" >
<entity name="systemuser" >
<condition attribute="systemuserid" operator="eq" value="7a990633-c4e8-ea11-a817-000d3a6aa4e3" />
<link-entity name="teammembership" from="systemuserid" to="systemuserid" intersect="true" >
<link-entity name="team" from="teamid" to="teamid" intersect="true" >
<attribute name="name" />
<condition attribute="isdefault" operator="eq" valueof="systemmanaged" />
<condition attribute="teamid" operator="neq" value="2e80b3c2-289e-ea11-a812-000d3a795762" uiname="Field Service - Resource" uitype="team" />
<link-entity name="teammembership" from="teamid" to="teamid" intersect="true" >
<link-entity name="systemuser" from="systemuserid" to="systemuserid" intersect="true" >
<link-entity name="bookableresource" from="userid" to="systemuserid" >
<attribute name="name" />
<link-entity name="msdyn_warehouse" from="msdyn_warehouseid" to="msdyn_warehouse" >
<attribute name="msdyn_name" />
Try View Designer plugin of XrmToolBox to apply your query to a custom view:
i did use this tool before for my other Views but here i need to pass some variables/parameters in order to get results.
I am searching a way in which one fetch xml result will be the input parameters of other view.
It would be difficult to pass result of a fetchxml as parameter to the OOB view control, because only one fetchxml can be applied to the view by default.
As far as I know, the OOB view control only accept some simple parameters, e.g: My active xxx records.
You could build a custom PCF control and replace the default control with it to support complex query.
Business Applications communities