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