You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2019/12/25 14:02:45 UTC
[GitHub] [incubator-superset] saurabh1-singh commented on issue #8892: Jinja
Template not working in case of view query
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:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org