We have a sprint which completed. In database, complete date value empty. how to fix mismatch?

Question

We have a sprint which was closed. In GUI, sprint showing as Completed. But in database, we dont see this status updated. COMPLETE DATE for that sprint is EMPTY.

How to  fix this mismatch between database and JIRA GUI.

Note: we have tried to run the Workflow integrity checker and see. But, it didnt help. can you please  suggest solution.

Nic Brough -Adaptavist- · Answer

Use the REST API to read the data you need!

Kishore D_suzx08 · Answer

Thanks for Response.
can we have any workaround for this? to bring them in same page?
i mean any WA  like  reopen of sprint and close again will give expected result?

Nic Brough -Adaptavist- · Answer

Stop reading the database, it's not designed for reporting, it's complicated, messy, and not structured in the way you are guessing it is.