Delete Draft contents automatically

Kalaiselvan shared this idea 15 months ago
Idea Logged

Hi Team,

This is regarding with the Draft report that created by the user. The Draft contents will not be deleted automatically unless the user delete the report manually.

It would be great if you create a clean-up job in order to reduce the no of draft/unused reports from the queue to avoid space consumption from the server.


For example, If we run job to delete the draft reports which is not used more then specific days (ie. 30 days, 60 days, 90 days etc). This patch to be run automatically and periodically.

Thanks Kalaiselvan

Comments (5)

photo
1

Hi Kalaiselvan,

Thank you for the idea. I have raised this as an idea with our dev team. If this is implemented I will advise you accordingly.

Jira Reference : YFN-11667

Regards,

Paul

photo
1

Hi

Do you know if this idea is implemented in any recent release?

Regards,

Bharath

photo
1

Hi Bharath,

There have been notes placed onto this ticket, which reflect that they will be looking at this in the second half of the year. We might have some scripts in the mean time, which might be of use. Would you like me to source these for you?

Thanks,

Paul

photo
1

Hi Paul,

I can use the sql: delete from reportheader where reportstatuscode = 'DRAFT'. If you have any apart from this, please share.

Regards,

Bharath

photo
1

Hi Bharath,

This should be all that is required and there is no specific magic sql script :). I will follow up though on this idea once there is movement on this.

Thank you,

Paul