Nested orgs were not being rendered as individual pages because of the limited URL-matcher in the controller (they have ids that looks like HCMC1_1). I've fixed that in dev and live, and I don't think there are any side-effects.
At RS's request, changed the field size of ttl_notes from 1024 to 2048.
If I do the query for 12-14 years olds in 1729 to 1759
with no grouping I get 18 hits (1 trial with 2 charges, 1 trial with 3)
with criminal_id grouping (i.e. table query) I get 15 hits (correct result, counting trials rather than charges)
with crime_group and year grouping (i.e. chart query) I get 13 hits. Two of the trials found by the table query are not found by this query.
I haven't been able to figure out why not. Will have to look in more detail at the GROUP BY directive and whether the "missing" records have gappy data causing the GROUP BY directive to skip them.
WJL is now set up on Transifex and in the process of translating the 2.2 interface. When 2.2 is released (next week-ish), what's done already will be ported over to the 2.3 translation track, and the aim is for us to upgrade our install first to 2.2 and then to 2.3, and thus inherit the translation.
Discussed plans with JP and SA for HCMC committee project.
Added more functionality to the demo (parallel zone outlines on both screens). The code is now pretty messy and ready for a rewrite; it's definitely just a pilot. The thing works, but only because of lots of try/catch things. Also tested the PPTX output from LibreOffice on the Windows VM, but it's horrible; that's not really an option. If we must use other people's hardware, we'll need to rework everything into PDFs that go point by point.
On late duty.
Two alarms (not drills) over the last few days have eaten up about two hours.
Implemented handling for the situation where orgs are nested inside larger orgs, and for the use of person/@corresp to point to a person in the personography from an org/listPerson. The processing goes like this: any org you ask for (on its own page, or through AJAX) will be processed with its own heading and note elements, along with a list of all its descendant person elements (from nested sub-orgs); however, the suborgs will not be directly referenced unless they are explicitly mentioned and linked in the note. Tested in dev and ported to live.
Tested the presentations on the projector, with my new laptop (unknown quantity, needs adaptors, has hidpi); tweaked a couple of things, but basically it worked OK.