Error "Undefined offset: 0" from complex query


#1

Hi, so here’s my problem:
I have several related tables which I like to GET.

This works:
host/api/v2/mysql/_table/initiative?&filter=(closed=false)and(published=true)&limit=2&offset=0&include_count=true

This stopped working after the Update to 2.9.0:
host/api/v2/mysql/_table/initiative?&filter=(closed=false)and(published=true)&limit=2&offset=2&include_count=true&ids=7,9,10,14,15,19,21,20,22,26,31,33

I always get an error with the message “Undefined offset: 0” and the Code 500.
It has worked before and stopped when I updated to 2.9.0.

I tried to remove limit and offset from the query, which did not yield a positive result.
The only other difference is obviously the list of ids that should be retrieved.

To me it seems like an PHP error. How can I solve this?

Thanks for any insight.


#2

It seems, linke the filter closed=false and published=true does not work well with the ids list.
In fact, I get all the entities from the id list and the filter is ignored.

Can it be that I just can’t use pagination in combination with a list of ids?


#3

I now resolved to transforming the ids parameter into a filter, which works like (id=0) or (id=5) or …
:neutral_face: