Hi,
we have changed the displayed name of this table
When doing some sql questions, and trying to use filters
sql uses original name
but filters uses displayed name
and then, it gives an error
How Can I fix it?
thanks
Hello there,
Try removing table and columns aliases (AS statements) and turn CTEs (WITH statements) to subqueries.
These cause trouble because the {{perSelect}} will be replaced with the schema + table + column you're mapping to: "DWGOLD"."SANCTIONS_TRANSIT"."DATA".
If you're using a CTE or aliasing, then you could have changed how this table and column should be referenced from that point in the query, and this can result in invalid SQL
Some more docs about field filter gotchas:
Thanks!!!