Downloads Documentation Community
Contribute
Contribute Demo






Show Sidebar
Login | Register


Changeset 4170

Show
Ignore:
Timestamp:
05/12/08 10:17:10 (7 months ago)
Author:
djazayeri
Message:

sync branch: don't search on voided patient identifiers

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • openmrs/branches/data_synchronization_bidirectional/src/api/org/openmrs/api/db/hibernate/HibernatePatientDAO.java

    r4161 r4170  
    162162                Query query; 
    163163                 
    164                 String sql = "select patient from Patient patient, PersonName name join patient.identifiers ids where ids.identifier = :id and patient.patientId = name.person.personId"; 
     164                String sql = "select patient from Patient patient, PersonName name join patient.identifiers ids where ids.voided = false and ids.identifier = :id and patient.patientId = name.person.personId"; 
    165165                String order = " order by name.givenName asc, name.middleName asc, name.familyName asc"; 
    166166                 
    …… 
    190190                 
    191191                Criteria criteria = sessionFactory.getCurrentSession().createCriteria(PatientIdentifier.class); 
     192                criteria.add(Restrictions.eq("voided", false)); 
    192193                criteria.setProjection(Projections.property("patient")); 
    193194