Re: [I] Cannot load filter Error: ORA-00979: not a GROUP BY expression [superset]

["mgundelfinger (via GitHub)" <gi...@apache.org>]

mgundelfinger commented on issue #28327:
URL: https://github.com/apache/superset/issues/28327#issuecomment-3589680239

   It still doesn't work for me, I am able to get around this by wrapping the column in a TRIM() function like this:
   
   <img width="306" height="171" alt="Image" src="https://github.com/user-attachments/assets/3f184f60-f7b5-4b76-8270-53e8362e612c" />
   
   <img width="332" height="222" alt="Image" src="https://github.com/user-attachments/assets/96e54566-2712-42c1-b7b8-d255e2e2d99d" />
   
   If i click "View query" after updating the chart, "GROUP BY 1" will be replaced with "GROUP BY TRIM(column_name)".
   
   This fixes the issue I had with rendering charts, however I haven't found a workaround for the filter function, as well as cross-filters.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org