Confluence User •

27 Jun, 2022 •

confluenceUser •

•

confluenceUser •

Hi,

not sure what expired processes mean, but I'm assuming the state is "open.not_running.suspended". You can delete them manually based on their states.

Ref: Development Server Data Cleaning - Knowledge Base for DX 7 - Joget | COMMUNITY

You can check available the type of states in the shkprocessstates table.

Confluence User •

27 Jun, 2022 •

confluenceUser •

•

confluenceUser •

Hello Ian,

An expired process is like a process created one year/ a long time ago. Although nobody has closed it, it should be regarded as "expired" and automatically be "shut down".

Is there any tool to automatically shut down those processes which are beyond certain period?

Confluence User •

28 Jun, 2022 •

confluenceUser •

•

confluenceUser •

Hey,

Well, there's an app in the marketplace:
https://marketplace.joget.org/jw/web/userview/mp/mpp/_/vad?id=APP_monapp (if you're using mysql)
https://marketplace.joget.org/jw/web/userview/mp/mpp/_/vad?id=APP_monappmssql (if you're using mssql)

You could probably modify the codes in there to meet your use case. 

Or, use a scheduler plugin to run a beanshell/database update tool to perform monthly (up to you) clean up, you have to code it though

https://marketplace.joget.org/jw/web/userview/mp/mpp/_/vad?id=scheduler_v6-1

Hope this helps

1

CSV | Excel | XML | PDF