Exporting records using filter with multiple (OR) values, efficiently

Role Image


I’m trying to export specific records so I can change their values. I’m trying to update the appointment status of in my appointments table of specific patients based on their Medical Record Number. 

What I’m using now is the “Advanced Filters”. It’s useful to filter only 5-10 patients based on their MRN. 20 to 30 is exhaustive. 

There might come a time that I need to get appointments from 5000+ patients, maybe even more. 

Is there a more efficient way to export these records? 

I’ve tried using FetchXMLBuilder from XrmToolbox. I can get the data easily there but I proved unusable because it does not have the first three columns for re-importing. 

Source link

Leave a reply

Please enter your comment!
Please enter your name here