Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
Bulk Deletion Jobs in Dynamics 365 allow you to build a query and then bulk delete records in the system that match that query. To save time, you can use an existing System or Personal view when building your Bulk Deletion criteria. However, there is one very dangerous issue with this.
In Advanced Find, you can build left-join queries, using the “Does Not Contain Data” operator on joins. For example, the screenshot below shows a query that will return all Accounts in the system that do not have any Contacts. I have saved this as a Personal View called “Accounts with no Contacts”.
This view returns one result – “Frosty’s Icecream Store”.
Note that there are 10 Accounts in the system that do have Contacts listed against them.
If we use this Personal View and then use it in a Bulk Deletion Job, the Bulk Deletion criteria will strip off the “Does Not Contain Data” operator and will think that the user hasn’t specified any search criteria. There is no way to add the “Does Not Contain Data” operator back into the criteria from the Bulk Deletion Wizard.
If you click on Preview Records, it will show you all 11 Accounts, including “Frosty’s Icecream Store”.
Continuing through the wizard will delete all Accounts, which obviously is very dangerous.
To sum up, be very careful with your Bulk Deletion Jobs and make sure you always click on Preview Records to make sure that you are deleting the data that you need to delete.
Business Applications communities