dhis2-devs team mailing list archive
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).
"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?