jbressand commented on issue #17097: URL: https://github.com/apache/superset/issues/17097#issuecomment-948577602
Steve Marek (TRAC VC) helped me find a workaround with Jinja tempates :  I build a saved query from my second dataset and I display this saved query in a table : `SELECT prix, login from taux_horaire where 1=1 {{ "AND login IN (SELECT login FROM dispos WHERE dispo IN ( '" + "','".join(filter_values('dispo', remove_filter=True)) + "') ) " if filter_values('dispo') is defined and filter_values('dispo') else "" }}` Here is our discussion : https://app.slack.com/client/T7GMC60JX/CCKHMGRRB/thread/CCKHMGRRB-1634639904.159900 I will build a dashboard with real datasets and verify there is no performance issues. -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
