Uploaded image for project: 'Click'
  1. Click
  2. CLK-372

PropertySelect ordering issue

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 1.5 M1
    • 1.5 M2
    • core
    • None

    Description

      If a PropertySelect is assigned a select query with ordering, it will still apply ordering by option label as well, which may lead to duplicate columns in the ORDER BY clause.

      PropertySelect.loadOptionList():
      ...
      if (getSelectQuery() != null) {
      SelectQuery query = getSelectQuery();

      if (getOrdering() != null && !orderingApplied)

      { query.addOrdering(getOrdering()); orderingApplied = true; }

      else if (getOptionLabel() != null && !orderingApplied)

      { query.addOrdering(getOptionLabel(), true); orderingApplied = true; }

      ...

      Attachments

        Activity

          People

            medgar Malcolm Edgar
            lpammer Lena Pammer
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: