Uploaded image for project: 'OpenMRS Core'
  1. OpenMRS Core
  2. TRUNK-5359

Syntax error in HibernatePersonDAO search query

    XMLWordPrintable

Details

    Description

      InĀ link HibernatePersonDAO

      Line # 177-178 read:

      q.append(" order by pname.givenName asc,").append(" pname.middleName asc,").append(" pname.familyName asc").append(" pname.familyName2 asc");

      There should be a comma at the end of "familyName asc" clause to avoid SQL Syntax error. Interestingly, this issue doesn't exist in master, I just saw it in 1.11x.

      Gliffy Diagrams

        Attachments

          Activity

            People

              owais.hussain Owais Hussain
              owais.hussain Owais Hussain
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 1 hour Original Estimate - 1 hour
                  1h
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 hours
                  2h