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.hispviet...@gmail.com On Sun, Mar 23, 2014 at 2:22 AM, sumudu weerasinghe <sumudu...@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 > ( 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@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : 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
