FetchXML improve for us to achieve more


A colleague challenged the author to set owners on accounts with a team that has the same name as the account. The author demonstrates how to achieve this using FetchXML queries. They start with a simple query to retrieve all accounts and then join with teams using the team name as the linking attribute. The author also adds a filter to exclude accounts that already have the correct owner. They mention a tool called Bulk Data Updater for XrmToolBox that can be used to set the owners using the query. The author also mentions that FetchXML Builder can be used to create queries that are not yet supported in the tool. They promise that FetchXML Builder will continue to improve and support new features.


Article 15m

Login now to access my digest by 365.Training

Learn how my digest works
Features
  • Articles, blogs, podcasts, training, and videos
  • Quick read TL;DRs for each item
  • Advanced filtering to prioritize what you care about
  • Quick views to isolate what you are looking for right now
  • Save your favorite items
  • Share your favorites
  • Snooze items you want to revisit when you have more time