Page 1 of 1

Dubplicate caseids in mysql

Posted: April 21st, 2018, 12:16 am
by ntliem
Hello,
I have a situation: some cases are duplicate in mysql because they were put from two or more devices.
Can I only keep the newest case in mysql?
Thanks,

Re: Dubplicate caseids in mysql

Posted: April 24th, 2018, 11:23 am
by josh
There is no automated way to do this in mysql. You should download the data using DataViewer and then remove the duplicates in the downloaded cspro data file.

We recommend designing your application in such a way that you avoid creating duplicate cases in the first place.