issues-table; closed_on - column should be updated to NULL whenever issue's status is changed to a 'is_closed == 0' status
The column "closed_on" was filled in issues table for some issues that were not closed.
It seems as if the column gets filled with the current timestamp if the issue's status is changed to a status that is marked as "is_closes" 1 in status table.
But if issues get changed back to a status that is not closed ("is_closed" 0) the issue column "closed_on" still is filled with the timestamp the status changed to a "is_closed" 1 status
Requested behaviour: If a issue gets a status that is "is_closed" 0 an issue has "closed_on" != NULL the "closed_on" column should be set to NULL.
#2 Updated by Go MAEDA over 2 years ago
#3 Updated by Florian S. over 2 years ago
Go MAEDA wrote:
Could you describe the detail why you want Redmine to clear the closed_on field? You can exclude reopened issues by using issues filter.
Thank you for your answer. I did not know that this is a wanted behaviour for this field. The name intents to interpret this as "THE closing date" and not "LAST closing date".
I have some separate reports that are realized via sql / access to redmine database and I used "closed_on" to identify the state "closed" or "open". Now I use the 'is_closed'-attribute from the status sql table for my extractions. So I do not really need a changed behaviour. But I thought if the behaviour is wrong it should be corrected in the redmine sources. If my intention for "closed_on" was wrong please reject this issue.