Task extended table Active flag state management

[ShAn21]

Hi Team,

I have a custom table extended from task. Ideally after the action is completed the state has to be set as 'Passed'. I am confused about the active flag management here. 

Bcoz I have a job to check if this was passed 6 months ago I need to set the state as 'Expired'. So the question here is whats the best way to maintain active flag. Is it better to keep it active as true till its Expired or make it false when the action is done and the state as Passed.

If its active false is it okay to edit the states of tasks later on? I am of that thought if a task is closed no further update must happen possibly except worknotes maybe.

Any feedback here would be appreciated.

Thanks

[Maik Skoddow · Accepted solution]

Hi

if I were you, I would set your record to active="false" when it is set to "Expired". The reason is what you already assumed: Only in case really nothing will change anymore, a task record should be set to inactive.

One hint: 
Please check the following helpful article. If your table is inherited from the task table you also inherit all the "magic" functions in the background and without the knowledge of it you will not understand why your custom table records behave "strange": https://community.servicenow.com/community?id=community_blog&sys_id=264d6229dbd0dbc01dcaf3231f96195a

Maik