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)
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