dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #51912
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