api/events/index/MonitorId:1.json "limit" and sort order query parameters no longer work in recent versions

[MarsRover]

Hello
Starting from 1.37.66~20250612.323-focal call to

Code: Select all

api/events/index/MonitorId:1.json?sort=StartDateTime&direction=desc&limit=1

disregards `limit` query parameter and returns all events (which might take a while).

Code: Select all

5.15.0-139-generic #149~20.04.1-Ubuntu SMP Wed Apr 16 08:29:56 UTC 2025 x86_64 x86_64 x86_64 GNU/Linux

[MarsRover]

Had to downgrade to 1.37.66~20250520.297-focal, all higher versions completely ignore limit, sort and direction query parameters.

[iconnor]

Events are now unlimited by default, you have to pass limits into the query.

How to downgrade? apt install zoneminder=whatever version you want

How to see what versions are available ? apt-cache madison zoneminder

[iconnor]

I realise that you are passing limit... I"m not sure it was ever actually honoured. Maybe it was. THe code that got removed use ZM_EVENTS_PER_PAGE and a hard limit of 100.

I hust added a line to respect a limit param... not sure about the direction= in your url... not sure that is honoured by anything.

Isaac

[MarsRover]

I hust added a line to respect a limit param... not sure about the direction= in your url... not sure that is honoured by anything.
Isaac

Thanks, I'll check if it works later.

The goal of this query is to get only the last/current event.
direction query parameter is documented here https://zoneminder.readthedocs.io/en/la ... ted-events, it's the sort field order, ascending or descending.

It did work before.

[MarsRover]

OK. limit in query is now regarded.

But no sorting!

I want to accomplish very simple task via API: get the list of last N events for a given monitor, including incomplete one (the current one being recorded).
It all worked fine until recent updates.

I don't want to mess-up with DB directly to achieve such a simple task.

What am I doing wrong?

[MarsRover]

I want to accomplish very simple task via API: get the list of last N events for a given monitor, including incomplete one (the current one being recorded).
It all worked fine until recent updates.
I don't want to mess-up with DB directly to achieve such a simple task.

OK, here's my solution
this bash code gives me 3 last events for MonitorID 1
)))

Code: Select all

#!/bin/bash
monId=1
nLastEvents=3
curl -sS --noproxy '*' -XGET "http://localhost/zm/api/events/index/MonitorId:${monId}/StartDateTime%20>=:$(mysql --batch --skip-column-names --skip-pager --execute="select REPLACE(StartDateTime, ' ', '%20') AS EncodedSDT from zm.Events where MonitorId = ${monId} ORDER BY Id DESC LIMIT $(( nLastEvents-1 )),1;").json"

All this instead of simple

Code: Select all

zm/api/events/index/MonitorId:1.json?sort=StartDateTime&direction=desc&limit=3

which worked fine at least in May (and still works in 1.37.66~20250520.297).

Maybe it's time to make my own events API, but I'm facing the risk of DB schema changes.

[iconnor]

If you put pagination=true in the query it should restore the old behaviour of returning paginated results.