I defined the field filter in my query as shown below -
but I encountered an error -
when I applied it manually without the field filter, it worked as expected.
Any idea what can be the issue?
From the SQL Question - can you add values to the Filters and then click the "eyeball" icon on the right to see what SQL is generated for the question?
I understand the issue, it's because of the alias of the table (da and sv).
When I removed it, it works.
1 Like
Yes - good eye!
Now that I can see the filters and the table, I’ve noticed an issue.
For example, I have a row with an ID of 229 ("Test ReadOnly") , where the company size is "1-100" and the project type is "Change Request."
However, when I filter the table by company size, the project type value is removed from the row, and when I filter by project type, the company size value disappears.
