Filter documentation

Administrators
1

Hi,

Is they are somewhere a example or better a documentation about Event.query.filter ?

I try to get the number of event created after a date.

Less useful but still…number of user account create after a date.

Regards

2 
Event.query.filter(Event.created_dt >= dt(2025, 7, 1)).count()
User.query.filter(User.created_dt >= dt(2025, 7, 1)).count()

dt is basically a shorthand for the Python datetime constructor, but it also adds timezone information so it can be easily used w/ the timezone-ware timestamps used in most of Indico’s models.

3

Thanks @ThiefMaster , I find out …half of the command… :wink: