There are lots of searches, unfortunately in old php, so the websites are long gone at https://therion.speleo.sk/wiki/contrib:databasequery:install It looks like Searches/Who might have the search you need. But might be useful for other things, if the php does not get in the way too much Andrew On 06/03/2025 16:49, Eoghan via Therion wrote:
Hi Benedikt,
I wrote up this for you as an example.
SELECT DISTINCT p.NAME, p.SURNAME, SUM(c.LENGTH) OVER(PARTITION BY p.NAME) as sum_len FROM PERSON p JOIN TOPO t ON p.ID = t.PERSON_ID JOIN CENTRELINE c ON c.ID = t.CENTRELINE_ID;
I hope this get’s you started.
Eoghan
On 20 Feb 2025, at 13:54, Benedikt Hallinger via Therion <therion@speleo.sk> wrote:
Hi, before I dig into SQL myself, does by chance somebody already made a script or SQL to generate a list showing: "who has drawn how much length of the surveys".
Something along: Person A: 250m Person B: 199m Person C: 80m ...
Thank you :) _______________________________________________ Therion mailing list Therion@speleo.sk https://mailman.speleo.sk/listinfo/therion
_______________________________________________ Therion mailing list Therion@speleo.sk https://mailman.speleo.sk/listinfo/therion