Skip to main content

Notifications

Announcements

No record found.

Service | Customer Service, Contact Center, Fie...
Answered

Add a filtering in the worker order list view

(1) ShareShare
ReportReport
Posted on by 8
Hi,
 
In the work order list view, I would like to add a filter that depends on the current user.
There is a default column /Reserved Ressources/ that we can see in grid (meaning the user has been booked for the work order). I would like to filter on it but I can't. When I try to add /Reserved Ressources/ to the filter, it can't find the field...
 
I downloaded the XML grid
 
<fetch version=/1.0/ output-format=/xml-platform/ mapping=/logical/ savedqueryid=/70518e86-6ec4-ed11-b596-0022482d11ed/ no-lock=/false/ distinct=/true/>
<entity name=/msdyn_workorder/>
<attribute name=/msdyn_serviceaccount//>
<attribute name=/msdyn_priority//>
<attribute name=/msdyn_systemstatus//>
<attribute name=/msdyn_substatus//>
<attribute name=/createdon//>
<attribute name=/msdyn_primaryincidenttype//>
<attribute name=/msdyn_name//>
<attribute name=/msdyn_workorderid//>
<attribute name=/msdyn_bookingsummary//>
<order attribute=/createdon/ descending=/true//>
<filter type=/and/>
<condition attribute=/statecode/ operator=/eq/ value=/0//>
</filter>
</entity>
</fetch>
 
 
I need to filter the current user on this field : <attribute name=/msdyn_bookingsummary//> (It display the ressource that has been booked for the work order)
 
How can I do this ?
 
 
 
Thanks in advance !
 
 
 
 
 
 
 
 
  • Verified answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    Add a filtering in the worker order list view
    Hi,
    Through testing:
    I don't see 'Reserved Resources' column in the work order table.
    As for the 'msdyn_bookingsummary' column you mentioned, his display name is 'Booking Summary', as well as the fact that he is a text column
    If you want to filter based on the current user criteria, only lookup fields related to the user can be used

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,622 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,354 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans