Allow changing group of tickets on drag
|Reported by:||dannysauer||Owned by:||robguttman|
It would be convenient if I there were support for the ability to change the queue on drag-and-drop as well. If I use a relatively simple statement for the field inserted as __group__ in my SQL like the below, it'd be nice if I could drag from one r.value group to another and have the value updated. As it sits, the sequence seems to be tracked properly between the grouped queues, but the grouped field is not updated when I drag from one queue to another.
SELECT s.value AS __color__, r.value AS __group__, p.value AS sequence, t.id AS ticket, summary, t.type AS type, t.severity, t.owner FROM ticket t LEFT JOIN enum s ON s.name = t.severity AND s.type = 'severity' LEFT OUTER JOIN ticket_custom p ON p.ticket = t.id and p.name = 'sequence' LEFT OUTER JOIN ticket_custom r ON r.ticket = t.id and r.name = 'rank' WHERE t.status <> 'closed' ORDER BY CAST((CASE p.value WHEN '' THEN '0' ELSE COALESCE(p.value,'0') END) AS INTEGER) ASC, t.changetime DESC
I suppose one would have to be able to tell if the field referenced is a valid field/customfield value, which makes this a tad harder. But I'd like to log it as a request none the less. :)