Discontinue automatically tasks after X time

[afauquem]

Hi,

I'm using a disconnected application with an Helpdesk connection. So we create tickets and retrieve their status.

I was wondering if there is a period after tasks in pending are automatically set as discontinue ? Like if after 30 days I don't get any update of the status, is there a configuration to automatically set the task as "Discontinue" or the task will still be in pending indefinitely ?

So, we need to create an enhanced query to check tasks older than 30 days and set their status from pending to discontinue ?

Thanks !

[rushikeshvartak · Accepted solution]

Yes currently task discontinued is not supported OOTB. You can create enhanced Query

SELECT 4 AS arstasks__status, taskkey AS arstasks__primarykey
FROM arstasks
WHERE
AND status IN (2,1)
AND taskdate < DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)

and ownertype=2