← Back to team overview

dhis2-users team mailing list archive

Re: Searching patient in Tracker not working?

 

Dear Sumudu,

This bug is fixed. Please update DHIS with revision 13830 or above (
version 2.14 ).

Best regards,
------------------------------------------------
Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@xxxxxxxxx


On Sun, Mar 23, 2014 at 2:22 AM, sumudu weerasinghe <sumuduw00@xxxxxxxxx>wrote:

> Dear all,
> I am customization tracker for mental health data and testing on it .
> I want to search patient by name and follow the following steps,
>
>    - services --> individual records --> find/add new patient --> advance
>    search
>
> I tried it for several times for pt name for different names (eg:ga...,
> name is a attribute create by me ) , but all the time *show similar list
> of patients* instead of one patient i want. ( i want to  see only ga...)
>  My log shows following all the time
>
>
>
>
>
>
>
>
>
>
> ** INFO  2014-03-22 23:56:29,280 Search patient SQL: select count(*)  from
> ( select distinct p.patientid,(select programid from programinstance pgi
> where patient id=p.patientid and programid=1244 limit 1 ) as prg_1244  from
> patient p  ) as searchresult where prg_1244=1244
> (HibernatePatientStore.java [http-apr-8084-exec-6])* INFO  2014-03-22
> 23:56:29,292 Search patient SQL: select *  from ( select dist inct
> p.patientid,(select programid from programinstance pgi where patientid=p.pa
> <http://p.pa>tientid and programid=1244 limit 1 ) as prg_1244  from patient
> p  ) as searchresult where prg_1244=1244 limit 50 offset 0
> (HibernatePatientStore.java [http-apr- 8084-exec-6])*
>
> I will attach my log file and screen shot.
> I am using
>   dhis 2.14
> Build revision:13807 Database type: PostgreSQL ( and try on mysql as well)
> OS name:Windows 7OS architecture:x86
>
> Are there any error in my method of test ??
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>

References