Hi everybody, If you have custom fields and want to export them with the regular ticket fields in columns, you need better-than-average knowledge of SQL. Should you not possess that, like me, it'll take you quite some time to come up with the sql stated below. So for you convenience, I have pasted what works for me. I have four custom fields: Where (location in the application of the reported ticket), withusername (which username was the reporter using), expected_behaviour (what should have happened) and observed_behaviour (what actually happened).
I used the CSV export to batch modify the usernames and re import it with the TicketImportPlugin (http://trac-hacks.org/wiki/ TicketImportPlugin), since I saw no way to get to the database directly. To use the statement, log in on your Agilo instance with SQL permissions on Reports, and alter an existing report, saving the original SQL, or create a new report if you know how. SELECT DISTINCT id, summary, reporter, owner, description, type, status, priority, milestone, component, version, resolution, keywords, cc, (CASE WHEN c.value ISNULL THEN '' ELSE c.value END) AS "where", (CASE WHEN d.value ISNULL THEN '' ELSE d.value END) AS "withusername", (CASE WHEN e.value ISNULL THEN '' ELSE e.value END) AS "expected_behaviour", (CASE WHEN f.value ISNULL THEN '' ELSE f.value END) AS "observed_behaviour" from ticket t left outer join ticket_custom c ON (t.id = c.ticket and c.name = 'where') left outer join ticket_custom d ON (t.id = d.ticket and d.name = 'withusername') left outer join ticket_custom e ON (t.id = e.ticket and e.name = 'expected_behaviour') left outer join ticket_custom f ON (t.id = f.ticket and f.name = 'observed_behaviour') -- Follow Agilo on Twitter: http://twitter.com/agiloforscrum ----- You received this message because you are subscribed to the Google Groups "Agilo for Scrum" group. This group is moderated by agile42 GmbH http://www.agile42.com and is focused in supporting Agilo for Scrum users. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/agilo?hl=en
