https://www.redmine.org/https://www.redmine.org/favicon.ico?16793021292019-05-22T07:06:20ZRedmineRedmine - Defect #31420: issues-table; closed_on - column should be updated to NULL whenever issue's status is changed to a 'is_closed == 0' statushttps://www.redmine.org/issues/31420?journal_id=919592019-05-22T07:06:20ZGo MAEDA
<ul><li><strong>Related to</strong> <i><a class="issue tracker-2 status-5 priority-4 priority-default closed" href="/issues/824">Feature #824</a>: Add "closed_on" issue field (storing time of last closing) & add it as a column and filter on the issue list.</i> added</li></ul> Redmine - Defect #31420: issues-table; closed_on - column should be updated to NULL whenever issue's status is changed to a 'is_closed == 0' statushttps://www.redmine.org/issues/31420?journal_id=919612019-05-22T07:09:14ZGo MAEDA
<ul></ul><p>I think the behavior is intended design. The field keeps the "last" closed time. Please see <a class="issue tracker-2 status-5 priority-4 priority-default closed" title="Feature: Add "closed_on" issue field (storing time of last closing) & add it as a column and filter on the... (Closed)" href="https://www.redmine.org/issues/824">#824</a> and the comment in <a class="changeset" title="Adds closed_on column that stores the time of the last closing (#824). The value is preserved wh..." href="https://www.redmine.org/projects/redmine/repository/svn/revisions/11402">r11402</a>.</p>
<p>Could you describe the detail why you want Redmine to clear the closed_on field? You can exclude reopened issues by using issues filter.</p> Redmine - Defect #31420: issues-table; closed_on - column should be updated to NULL whenever issue's status is changed to a 'is_closed == 0' statushttps://www.redmine.org/issues/31420?journal_id=919682019-05-22T10:51:32ZFlorian S.
<ul></ul><p>Go MAEDA wrote:</p>
<blockquote>
<p>I think the behavior is intended design. The field keeps the "last" closed time. Please see <a class="issue tracker-2 status-5 priority-4 priority-default closed" title="Feature: Add "closed_on" issue field (storing time of last closing) & add it as a column and filter on the... (Closed)" href="https://www.redmine.org/issues/824">#824</a> and the comment in <a class="changeset" title="Adds closed_on column that stores the time of the last closing (#824). The value is preserved wh..." href="https://www.redmine.org/projects/redmine/repository/svn/revisions/11402">r11402</a>.</p>
<p>Could you describe the detail why you want Redmine to clear the closed_on field? You can exclude reopened issues by using issues filter.</p>
</blockquote>
<p>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".<br />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.</p> Redmine - Defect #31420: issues-table; closed_on - column should be updated to NULL whenever issue's status is changed to a 'is_closed == 0' statushttps://www.redmine.org/issues/31420?journal_id=919702019-05-22T12:21:02ZGo MAEDA
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Closed</i></li><li><strong>Resolution</strong> set to <i>Invalid</i></li></ul><p>Thank you for clarifying and understanding. I am closing this issue.</p>
<p>Please don't hesitate to report a bug if you think a behavior weird.</p>