Hi Georgi, You can always create a query that identifies duplicates based on any number or combination of parameters. The query could then be wrapped in a report that end users can run ad hoc.
Best - - Busoye Anifalaje (PhD) Director of Services (Principal), BAO Systems UK: +44 7901-740-757 | US: +1 682-307-0986| bus...@baosystems.com <mailto:bus...@baosystems.com> | http://www.baosystems.com <http://www.baosystems.com/> | Skype: busoye | 2900 K Street, Suite 406, Washington D.C. 20007 > On 12 Sep 2017, at 08:18, Georgi Chakarov <geo...@logicaloutcomes.net> wrote: > > Hi, > > This will not work, because each of this attributes can have a duplicate. > E.g. you might have two persons by the name of “John”. It is the combination > of those attributes that needs to be unique, as it is less likely to have two > people with the same First Name and Surname, born on the same date. > > There should be another solution. Our clients are very surprised how a system > is unable to lookup in the existing records and identify duplicates. Anyone? > > Georgi > > From: Abyot Asalefew Gizaw [mailto:ab...@dhis2.org <mailto:ab...@dhis2.org>] > Sent: Tuesday, September 12, 2017 10:13 AM > To: Stanley Kalyati <skaly...@gmail.com <mailto:skaly...@gmail.com>> > Cc: Georgi Chakarov <geo...@logicaloutcomes.net > <mailto:geo...@logicaloutcomes.net>>; DHIS Users > <dhis2-users@lists.launchpad.net <mailto:dhis2-users@lists.launchpad.net>>; > DHIS 2 Developers list <dhis2-d...@lists.launchpad.net > <mailto:dhis2-d...@lists.launchpad.net>> > Subject: Re: [Dhis2-users] Avoid double registration of Tracked entities > > Hi, > > The only possibility we have at the moment is if you make those attributes > unique. > > -- > Abyot A. Gizaw. > Senior Engineer, DHIS2 > University of Oslo > http://www.dhis2.org <http://www.dhis2.org/> > > On Tue, Sep 12, 2017 at 7:10 AM, Stanley Kalyati <skaly...@gmail.com > <mailto:skaly...@gmail.com>> wrote: > Has anyone responded to this? Am also very interested. > > Thanks > > On Sep 10, 2017 11:22 AM, "Georgi Chakarov" <geo...@logicaloutcomes.net > <mailto:geo...@logicaloutcomes.net>> wrote: > Hello! > > Is there a way to avoid a double registration of Tracked entities? E.g. the > attributes are Name, Surname, Date of Birth, can I create a program rule that > searches if all three values match existing records to prompt a message that > a person with such attributes already exists? Another suggestion is also > welcome. > > Regards, > > Georgi > > > Georgi Chakarov, CIA | geo...@logicaloutcomes.net > <mailto:geo...@logicaloutcomes.net> | +1-647-478-5634 x 104 > <tel:(647)%20478-5634> | LogicalOutcomes c/o Centre for Social Innovation, > 720 Bathurst Street, Toronto Canada M5S 2R4 | You may unsubscribe from > receiving commercial electronic messages from LogicalOutcomes by emailing > i...@logicaloutcomes.net <mailto:i...@logicaloutcomes.net> > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > <https://launchpad.net/~dhis2-users> > Post to : dhis2-users@lists.launchpad.net > <mailto:dhis2-users@lists.launchpad.net> > Unsubscribe : https://launchpad.net/~dhis2-users > <https://launchpad.net/~dhis2-users> > More help : https://help.launchpad.net/ListHelp > <https://help.launchpad.net/ListHelp> > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > <https://launchpad.net/~dhis2-users> > Post to : dhis2-users@lists.launchpad.net > <mailto:dhis2-users@lists.launchpad.net> > Unsubscribe : https://launchpad.net/~dhis2-users > <https://launchpad.net/~dhis2-users> > More help : https://help.launchpad.net/ListHelp > <https://help.launchpad.net/ListHelp> > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > <https://launchpad.net/~dhis2-users> > Post to : dhis2-users@lists.launchpad.net > <mailto:dhis2-users@lists.launchpad.net> > Unsubscribe : https://launchpad.net/~dhis2-users > <https://launchpad.net/~dhis2-users> > More help : https://help.launchpad.net/ListHelp > <https://help.launchpad.net/ListHelp>
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
