Greenhopper Days Remaining in Sprint Gadget problem

[Jakob Rödström]

We are running the Labs feature "paralell sprints" and are currently hosting 2 sprints in the same board against the same backlog.

Trying to get the Days Remaining in sprint to work on our dash. The gadget is totally not working, see the snapshots below for more info:

https://dl.dropboxusercontent.com/u/33686/Atlassian/Screen%20Shot%202013-05-07%20at%2014.52.43.png

https://dl.dropboxusercontent.com/u/33686/Atlassian/Screen%20Shot%202013-05-07%20at%2014.52.49.png

https://dl.dropboxusercontent.com/u/33686/Atlassian/Screen%20Shot%202013-05-07%20at%2014.53.13.png

https://dl.dropboxusercontent.com/u/33686/Atlassian/Screen%20Shot%202013-05-07%20at%2014.53.24.png

[PD Sheehan]

Pretty much everything is in the DB.

Workflows are stored in the jiraworkflows and jiradraftworkflow tables.

But the trick will be to filter my modified date. There is no such column in the database. Instead, you'll have to find a way to look inside the value of the "DESCRIPTOR" column with is stored as XML.

You'll see a couple of XML nodes like this that might be helpful:

<meta name="jira.update.author.key">xxxx</meta>
<meta name="jira.updated.date">1646175344339</meta>

Where the date is stored as milliseconds since epoch time.

You'll have better luck in oracle forums for how to achieve that.