← Back to team overview

dhis2-devs team mailing list archive

filtering sqlview result using value with a colon

 

We have a sql view that includes a timestamp in it (dhis2 version 2.29),
and we are trying to filter the output, but get invalid filter error (409).

{
  "httpStatus": "Conflict",
  "httpStatusCode": 409,
  "status": "ERROR",
  "message": "Invalid filter => approvaltime:eq:2018-10-17 14:56:36.243"
}

Filtering by using just the date part works, but when time part is
included, it comes back with the above. I suppose colon in the value is to
blame, but have not seen any way of escaping it (at least nothing i've
tried works - espacing : using %3A, among others, and documentation does
not have anything either).

Is this something that is not supported?

Thanks,
Vlad