Re: [MacPorts] #42896: Could not sort tickets by status

23 Oct 2016

      #42896: Could not sort tickets by status
-----------------------------+---------------------
  Reporter:  xeron           |      Owner:  admin@…
      Type:  defect          |     Status:  closed
  Priority:  Normal          |  Milestone:
 Component:  server/hosting  |    Version:
Resolution:  fixed           |   Keywords:
      Port:                  |
-----------------------------+---------------------

Comment (by ryandesign):

 Report 9 was selecting the status column twice:

 {{{
 SELECT p.value AS __color__,
     id AS ticket, summary, component, version, milestone, t.status,
     t.type AS type, severity,
     owner, status,
     priority, time AS created,
     changetime AS _changetime, description AS _description,
     reporter AS _reporter
 FROM ticket t, enum p
 WHERE t.status <> 'closed'
 AND p.name = t.priority AND p.type = 'priority' AND reporter = '$USER'
 ORDER BY (status = 'assigned') DESC, p.value, milestone, severity, time
 }}}

 And also selecting the severity column, which we don't use. I changed it
 to:

 {{{
 SELECT p.value AS __color__,
     id AS ticket, summary, component, version, milestone,
     t.type AS type,
     owner, status,
     priority, time AS created,
     changetime AS _changetime, description AS _description,
     reporter AS _reporter
 FROM ticket t, enum p
 WHERE t.status <> 'closed'
 AND p.name = t.priority AND p.type = 'priority' AND reporter = '$USER'
 ORDER BY (status = 'assigned') DESC, p.value, milestone, time
 }}}

 -----

 Same with report 10:

 {{{
 SELECT p.value AS __color__,
     id AS ticket, summary, component, version, milestone, t.status,
     t.type AS type, severity,
     owner, status,
     priority, time AS created,
     changetime AS _changetime, description AS _description,
     reporter AS _reporter
 FROM ticket t, enum p
 WHERE p.name = t.priority AND p.type = 'priority' AND reporter = '$USER'
 ORDER BY (status = 'assigned') DESC, p.value, milestone, severity, time
 }}}

 I changed it:

 {{{
 SELECT p.value AS __color__,
     id AS ticket, summary, component, version, milestone,
     t.type AS type,
     owner, status,
     priority, time AS created,
     changetime AS _changetime, description AS _description,
     reporter AS _reporter
 FROM ticket t, enum p
 WHERE p.name = t.priority AND p.type = 'priority' AND reporter = '$USER'
 ORDER BY (status = 'assigned') DESC, p.value, milestone, time
 }}}

--
Ticket URL: <https://trac.macports.org/ticket/42896#comment:9>
MacPorts <https://www.macports.org/>
Ports system for OS X