Searching patient in Tracker not working?

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 ( sele
ct 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 se
archresult 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
tientid and programid=1244 limit 1 ) as prg_1244 from patient p ) as searchres
ult 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 7
OS architecture:x86

Are there any error in my method of test ??

search.txt (17.3 KB)

image

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@gmail.com

On Sun, Mar 23, 2014 at 2:22 AM, sumudu weerasinghe sumuduw00@gmail.com 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 ( sele
ct 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 se
archresult 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
tientid and programid=1244 limit 1 ) as prg_1244 from patient p ) as searchres
ult 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 7
OS architecture:x86

Are there any error in my method of test ??


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