Auto delete ConfiForms database

Adrian M May 14, 2024

My ConfiForms form creates Jira tickets. The database of the form is growing. The form does not store any ID's or timestamp's in the ConfiForms database.

Is there a way to set things up so that the last 100 rows are kept and any rows beyond that in the ConfiForms database are auto deleted by setting up a schedule.

Or rows created in the past 30 days are kept and any rows beyond that in the ConfiForms database are deleted by setting up a schedule?

1 answer

1 vote
Alex Medved _ConfiForms_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 14, 2024

You can use APIs to remove data from ConfiForms - https://wiki.vertuna.com/display/FORMS/REST+API+for+ConfiForms+CLOUD#RESTAPIforConfiFormsCLOUD-DeleteBy

(to run via some scheduler, like CRON, or something)

Adrian M May 15, 2024

How can I remove only a certain number of entries? I guess I'll need to save an ID or timestamp in the ConfiForms so that I can delete by querying that?

Currently my form does not save either ID or timestamp in the database. Should I set a hidden field(s) for that? or is there a better way to do that?

Alex Medved _ConfiForms_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 15, 2024

Each record has a created and some other fields 

You can filter by "created" field

Like Adrian M likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events