[SOLVED] $filter=created eq 1988-01-19T12:00:00Z

‘eq’ in ‘$filter=created eq 1988-01-19T12:00:00Z’ doesn’t seem to work this way?
Any idea?

  • [ ] Checked the logs and have provided uploaded a log file and provided a link because I found something suspicious there.

I’m submitting a…

  • [ ] Regression (a behavior that stopped working in a new release)
  • [ ] Bug report
  • [ ] Performance issue
  • [ ] Documentation issue or request

Current behavior

Expected behavior

Minimal reproduction of the problem

Environment

  • [ ] Self hosted with docker
  • [ ] Self hosted with IIS
  • [ ] Self hosted with other version
  • [ ] Cloud version

Version: [VERSION]

Browser:

  • [ ] Chrome (desktop)
  • [ ] Chrome (Android)
  • [ ] Chrome (iOS)
  • [ ] Firefox
  • [ ] Safari (desktop)
  • [ ] Safari (iOS)
  • [ ] IE
  • [ ] Edge

Others:

What problem do you see?

It doesn’t work for created/lastModified specifically. However for other userdefined datetime column it works.
For e.g. it works for $filter=data/displayDate/iv ge 2019-09-13T08:00:41Z but not for $filter=created ge/ge/eq 2019-09-13T08:00:41Z. I know there is data.

True, I will have a look asap.

Returns 0 records;
{
“total”: 0,
“items”: [],
“statuses”: [
{
“status”: “Archived”,
“color”: “#eb3142
},
{
“status”: “Draft”,
“color”: “#8091a5
},
{
“status”: “Published”,
“color”: “#4bb958
}
],
“_links”: {
“self”: {
“href”: “/api/content/sundarfac1/blog”,
“method”: “GET”
},
“create”: {
“href”: “/api/content/sundarfac1/blog”,
“method”: “POST”
},
“create/publish”: {
“href”: “/api/content/sundarfac1/blog?publish=true”,
“method”: “POST”
}
}
}

I have solved it and deployed the bugfix to the cloud.

1 Like