Dear OF team,
when i create a dataset in collect and successfuly import it to Calc i get an error if I want to filter tables according to dates. First of all, they are imported as text variables, which means you cannot filter for example years that are newer then 2001 (> 2001) and more importantly i cannot even use "=". For example filter results = 2017.
this is the error i get:
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: jOOQ; bad SQL grammar [select count(*) from "probaaaa"."a_gen_view" where "probaaaa"."a_gen_view"."date1_year" between ? and ?]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: integer >= character varying
Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Position: 89
any simple solutions?
