Replies: 5 comments
-
Generally, the problem is that I want to have a chart of sales by day from my database. table Orders: table Clients: table ClientGroups When I was on 0.999 version of superset I added table Orders as my Dataset clientId not in (select clientid from clients where clientGroupId=1) It worked perfect I know I can use custom sql with joined tables as datasource now and filter on joined clientGroupId value |
Beta Was this translation helpful? Give feedback.
-
We have encountered the same problem. Has this been examined or did you find a solution to enable it? |
Beta Was this translation helpful? Give feedback.
-
No |
Beta Was this translation helpful? Give feedback.
-
Encountered the same problem. The issue seems to be an overly aggressive detection of sub queries in filters. For example trying to extract epoch from a PostgreSQL interval causes this. My guess it is the "FROM" keyword. For example in something as:
I logged this as an issue here: |
Beta Was this translation helpful? Give feedback.
-
Getting the same error when I use JOINS |
Beta Was this translation helpful? Give feedback.
-
Hi!
I upgraded my superset from old 0.999dev to 2.01 and Got an error
Error: Custom SQL fields cannot contain sub-queries
on my charts
It's caused by Filter in most of my charts with SQL subquery in "Custom SQL" tab
Something like
Filters - Add - CUSTOM SQL
"WHERE"
ID not in (select id from someothertable where somefield='somevalue')
And everything works well when removing this filter
Is it a bug of new version?
And should I consider using other features to achieve same results ?
Beta Was this translation helpful? Give feedback.
All reactions