Relationship between sprint and issues tables

[farazahmad56]

I have created a sprint and added issues. I want to change the start/end date for the sprint. I have updated the START_DATE, END_DATE, ACTIVATED_DATE, and Complete_Date values from direct databases.  After updating the COMPLETE_DATE i am unable to view issues in Status Report from Sprint Report. If i change the COMPLETE_DATE  value to last auto inserted value it shows me the Status Report.

Please guide what I am doing wrong? 

[Nic Brough -Adaptavist-]

Welcome to the Community!

There is no relationship beween the sprint and issue tables, the code handles the logical connection, not the database.

What you're doing wrong is amending the database.  You should rarely amend a Jira database directly.  If you are going to do it, you need a thorough understanding of exactly what to do (because, frankly, the database is a mess as far as most humans would understand it, and not easy to get right), and significant downtime - you will damage it if Jira is running while you amend it externally.  Also, if you do take it offline, run SQL and restart, you then need to run a full locking re-index for the entire system.  Every time.