saurabh1-singh edited a comment on issue #5547: Adds a new macro to allow getting filter values easily URL: https://github.com/apache/incubator-superset/pull/5547#issuecomment-568066803 > This is useful if: > - you want to use a filter box to filter a query where the name of filter box > column doesn't match the one in the select statement > - you want to have the ability for filter inside the main query for speed purposes This does not work as mentioned in the PR, if the column in filter box does not match the one in the other visualization select statement, it throws error because it tries to wrap the query and apply the filter with the column name of the filter box. Steps to reproduce: SELECT col_1 FROM xyz where col_2 >= {{ something }} and col_2 < {{ something else }} After that I name the column in Filter Box "something" and "something else" but I get error "something" not present in expr_query, say, I pass value 123 in "something" column and 321 in "something else" The query generated is somewhat like this SELECT col_1 FROM xyz where col_2 >= 123 and col_2 < 321 and "something"=123 and "something else" = 321 What do i do to make the last line disappear from the final query output
---------------------------------------------------------------- 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]
