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

Syntax error in HibernatePersonDAO search query

    XMLWordPrintable

    Details

    • Complexity:
      Low

      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

              Assignee:
              owais.hussain Owais Hussain
              Reporter:
              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