[DEV] SQL procedures added

Tags: #<Tag:0x00007f6cdf862830> #<Tag:0x00007f6cdf862650> #<Tag:0x00007f6cdf8624e8>

Hi folks,

A word to let you know I’ve just added two SQL procedures to the install script.

The first one is last_audit(N) providing you with a list of the N last audits executed (written years ago by @koj but never added).

For the second one, a bit of context first.

Sometimes an audit may be stuck (typically because you restarted Tomcat while audits were running, you silly :wink: ). This leaves an “eternal hourglass” next to your contract.

The new list_current_acts is an SQL procedure that gives you the IDs of the act(s) and the audit you may delete to wipe out the eternal hourglass. Nice isn’t it ? :sunglasses:

1 Like
  • not added to the tar.gz runner?
  • “acts” : what is it ?