[SOLVED] Field Filter: ORA00904 error

Get Help
1

Hi. I’m trying to use a field filter on this query:
select card_id, operationdate, ticket_id, tfxmz, HCXIM
from LOGRECHARGE
where regtype in (1,2,11)
and operationdate >= to_date(‘01/01/2020’,‘dd/mm/yyyy’)
and {{atm}}

I selected the correct schema, table and column in the filter configuration but when the query is executed, an ORA00904 error is shown (ORA-00904: “COGA”.“LOGRECHARGE”.“ATM_ID” not a valid identifier). What can cause this?

2

Hi @RafaJ
On Oracle, you have to define the full FROM-clause as FROM "schema"."table" when using Field Filters
https://www.metabase.com/docs/latest/users-guide/13-sql-parameters.html#the-field-filter-variable-type

2 Likes
3

I thought I had tried that but seems I was wrong. Thank you.