Export Sprint details into a CSV/XML from JIRA

[rashmi]

hi

How can I export Sprint details (like rapidviewid, name , start date,end date) etc. into a CSV/XML file from JIRA UI?

Please help

Thanks

[cgauterio]

Hi there,

I am afraid that's not possible just yet. My suggestion is that you export this information via CSV file from the database. For example:

select "AO_60DB71_RAPIDVIEW"."NAME", "AO_60DB71_SPRINT"."NAME", to_timestamp("START_DATE"::bigint/1000) AS "START_DATE", to_timestamp("END_DATE"::bigint/1000) AS "END_DATE" 
  from "AO_60DB71_SPRINT", "AO_60DB71_RAPIDVIEW"
 where "AO_60DB71_RAPIDVIEW"."ID" = "AO_60DB71_SPRINT"."RAPID_VIEW_ID";

This is done using PostreSQL, and it might need some ajustments for other database.

Cheers,

Clarissa.