Hi Georgi,

Great to connect again. 

Abyot is right: unless you implement a unique identifier scheme for each 
record, there is currently no way to achieve what you want. If you can wait, 
the feature will eventually make it into the core s/w. 

Alternatively, if you can’t wait, what I was proposing was not for end users to 
run a query. Rather, the query would already be created with a standard report 
template (HTML?) to go with it. The end user would only be required to click on 
generate report. You can add parameters to the report like org unit (e.g. 
looking for duplicates within a specific org unit). 

Not sure you have many options at this stage.

Cheers.
    
- -




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:27, Georgi Chakarov <geo...@logicaloutcomes.net> wrote:
> 
> Hello Adebusoye!
> 
> Nice to hear from you again, since our meeting in London at the WW Summit!
>  
> Thank you for your thoughts! The thing is, I can’t really tell data entry 
> people, working on the field to run a query. They simply can’t. This needs to 
> be a user interface solution. Do you have other ideas in mind?
>  
> Georgi
>  
> From: Adebusoye Anifalaje [mailto:bus...@baosystems.com 
> <mailto:bus...@baosystems.com>] 
> Sent: Tuesday, September 12, 2017 10:23 AM
> To: Georgi Chakarov <geo...@logicaloutcomes.net 
> <mailto:geo...@logicaloutcomes.net>>
> Cc: Abyot Asalefew Gizaw <ab...@dhis2.org <mailto:ab...@dhis2.org>>; Stanley 
> Kalyati <skaly...@gmail.com <mailto:skaly...@gmail.com>>; 
> dhis2-users@lists.launchpad.net <mailto:dhis2-users@lists.launchpad.net>; 
> DHIS 2 developers <dhis2-d...@lists.launchpad.net 
> <mailto:dhis2-d...@lists.launchpad.net>>
> Subject: Re: [Dhis2-users] Avoid double registration of Tracked entities
>  
> 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
>  
> - -
>  
> 
> <image001.png>
> 
> 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 
> <mailto: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

Reply via email to