=== modified file 'dhis-2/dhis-services/dhis-service-patient/src/main/java/org/hisp/dhis/patient/hibernate/HibernatePatientStore.java' --- dhis-2/dhis-services/dhis-service-patient/src/main/java/org/hisp/dhis/patient/hibernate/HibernatePatientStore.java 2013-01-21 08:13:02 +0000 +++ dhis-2/dhis-services/dhis-service-patient/src/main/java/org/hisp/dhis/patient/hibernate/HibernatePatientStore.java 2013-02-18 08:42:43 +0000 @@ -410,7 +410,7 @@ } else if ( keys[0].equals( Patient.PREFIX_PROGRAM ) ) { - sql += "(select programid from patient_programs where patientid=p.patientid and programid=" + keys[1] + sql += "(select programid from patient_programs where patientid=p.patientid and programid=" + id + " ) as " + Patient.PREFIX_PROGRAM + "_" + id + ","; otherWhere += operator + Patient.PREFIX_PROGRAM + "_" + id + "=" + id; operator = " and "; === modified file 'dhis-2/dhis-web/dhis-web-caseentry/src/main/webapp/dhis-web-caseentry/javascript/patient.js' --- dhis-2/dhis-web/dhis-web-caseentry/src/main/webapp/dhis-web-caseentry/javascript/patient.js 2013-02-02 10:34:22 +0000 +++ dhis-2/dhis-web/dhis-web-caseentry/src/main/webapp/dhis-web-caseentry/javascript/patient.js 2013-02-18 08:42:43 +0000 @@ -32,15 +32,33 @@ jQuery('#loaderDiv').show(); contentDiv = 'listPatientDiv'; - jQuery('#listPatientDiv').load('searchRegistrationPatient.action',{ - listAll:true - }, - function(){ - setTableStyles(); - statusSearching = 0; - showById('listPatientDiv'); - jQuery('#loaderDiv').hide(); - }); + if( getFieldValue('programIdAddPatient')=='') + { + jQuery('#listPatientDiv').load('searchRegistrationPatient.action',{ + listAll:true + }, + function(){ + setTableStyles(); + statusSearching = 0; + showById('listPatientDiv'); + jQuery('#loaderDiv').hide(); + }); + } + else + { + jQuery('#listPatientDiv').load('searchRegistrationPatient.action',{ + listAll:false, + searchBySelectedOrgunit: true, + programIds: getFieldValue('programIdAddPatient'), + searchTexts: 'prg_' + getFieldValue('programIdAddPatient') + }, + function(){ + setTableStyles(); + statusSearching = 0; + showById('listPatientDiv'); + jQuery('#loaderDiv').hide(); + }); + } hideLoader(); }