How can I get the ticket status from the STEP_ID and issuestatus.Sequence in the JIRA Database

[luegen lord]

Hey there.

According to some specs I found, the STEP_ID in the OS_CURRENTSTEP and OS_HISTORYSTEP Table are supposed to match up with the issuestatus.Sequence number -- sadly, this is not the case. As it is right now, if I join on those two fields, the status of the ticket is wrong.

I'd appreciate the help.