[GitHub] [incubator-superset] saurabh1-singh edited a comment on issue #8892: Jinja Template not working in case of view query

[GitBox <gi...@apache.org>]

saurabh1-singh edited a comment 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 table_1) 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 user_id AS report_id,
          score AS score
   FROM table_1
   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