-
Notifications
You must be signed in to change notification settings - Fork 296
Description
Name: Flask-Restless
Version: 0.17.0
I am getting wrong results while filtering.
I have model defined like below:
class Session(Base):
...
start_time = Column(DateTime, nullable=False, default=get_current_utc_datetime)
end_time = Column(DateTime, onupdate=get_current_utc_datetime)
...
when I filter using simple date string
api/session?q={"filters":[{"name":"start_time","op":"ge","val":"2018-10-19"},{"name":"end_time","op":"le","val":"2018-11-19"}]}
I get 3 result. It does not include one result which has end_time "2018-11-19".
However when I filter using datetime iso string
api/session?q={"filters":[{"name":"start_time","op":"ge","val":"2018-10-19"},{"name":"end_time","op":"le","val":"2018-11-19T23:59:59.000Z"}]}
It returns 4 result which is correct.
It seems like edge case is not covered here when filtered using date.
Edit:
I also tried
api/session?q={"filters":[{"name":"start_time","op":"ge","val":"2018-10-19"},{"name":"end_time","op":"le","val":"2018-11-20"}]}
It returns 4 results.