saurabh1-singh commented on issue #8892: Jinja Template not working in case of view query URL: https://github.com/apache/incubator-superset/issues/8892#issuecomment-568902974 @villebro i did look at the query generated here is the diff - In the chart which shows error test_c_1, the query generated is as follows `SELECT user_id AS user_id FROM (select user_id, score FROM chqbook.fact_credit_profile_agg) AS expr_qry WHERE score_1 IN (700) AND score_2 IN (800) AND ((score >= '700' and score <= '800')) LIMIT 1000;` - While in the second chart its `SELECT report_id AS report_id, score AS score FROM chqbook.dim_credit_reports WHERE ((score >= '700' and score <= '800')) LIMIT 250;` As you can see here what i am trying to point out using a view on the datasource makes it fill the value in the template as well as apply the filter, while using the table directly as datasource does not add extra filter
---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
