{21} Tickets By Group (372 matches)

A script that updates all empty custom fields that are filled in the Group ticket of the correspondig ticket:

UPDATE trac.ticket_custom y 
SET    value = r.value 
FROM  ( SELECT 	q.ticket, 
		q.summary, 
		q.name, 
		w.value 
	FROM  ( SELECT  t.ticket, 
			a.summary, 
			a.name, 
			t.value AS group  
		FROM trac.ticket_custom t, 
		     (  SELECT  ti.summary, 
				c.* 
			FROM    trac.ticket ti, 
				trac.ticket_custom c 
			WHERE   c.ticket = ti.id AND 
				c.value = '' ) a 
		WHERE  	t.ticket = a.ticket AND 
			t.value like 'GROUP%' 
		ORDER BY t.ticket ) q 
	JOIN  ( SELECT  t.summary, 
			c.*  
		FROM    trac.ticket t, 
			trac.ticket_custom c 
		WHERE 	t.id = c.ticket AND 
			t.summary like 'GROUP%' AND 
			c.value != '' ) w 
	ON 	w.summary = q.group AND
		w.name = q.name) r 
WHERE   y.ticket = r.ticket AND 
	y.name = r.name;