Could not sort tickets by status

[xeron (Ivan Larionov)]

Trac web interface shows error when I'm trying to sort tickets by status:

Report execution failed:
ORDER BY "status" is ambiguous LINE 10: ...lue, milestone, severity, time ) AS tab ORDER BY "status" A... ^

Example link: report:9?sort=status&asc=1

Sorting by any other field works: report:9?sort=ticket&asc=1

Also status field shown 2 times. May be related.

[petrrr]

Is this still an issue or can this be closed?

[xeron (Ivan Larionov)]

You can easily verify it. I've provided a link which results in a error.

[xeron (Ivan Larionov)]

Fixed with a new trac. Feel free to close.

The only issue which is remaining is Status field shown twice.

[neverpanic (Clemens Lang)]

Thanks for the notice. Any idea why the status field is listed twice?

[xeron (Ivan Larionov)]

Not really. Last time I managed trac installation was like 8 years ago :)

[ryandesign (Ryan Carsten Schmidt)]

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