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 ). This leaves an “eternal hourglass” next to your contract.
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 ?