How to make a selection in migx via getimagelist with two conditions?

Question

PHP

The sidebar displays a list of the nearest current events from the migx table. So far, it has been done to display events with end dates greater than today's date. But there are positions in the table for which the date is specified (the field is not filled).
How it would be more optimal to make a selection from the base with two where conditions?

I see only one way out - by default, a value with a date for several years ahead is written in the field with an unknown date.

Answer 1

I think this should work - just select with a date older than today + if the date is not filled

&where=`{"eventEnd:>":"", "eventEnd:IS" => null}`