Templated filter yesno bug in looker 4.22.18


Hi there,

Is this a known bug of templated filters in looker 4.22.18?


- explore: test_view_dk

- view: test_view_dk
    sql: |
      with a as (select 0 as e1 union select 1 as e1)
      ,pre_nums as (
      select pow(2,0)*a0.e1+pow(2,1)*a1.e1+pow(2,2)*a2.e1+pow(2,3)*a3.e1 as num from a a0
      cross join a a1
      cross join a a2
      cross join a a3
      ,nums as ( select num, num<=5 as bl from pre_nums)
      select * from nums
      where {%condition yesno_filter %} bl {%endcondition%}

  - filter: yesno_filter
    type: yesno
<!---  type: string -->     
  - dimension: num
    type: number
    sql: ${TABLE}.num
  - dimension: bl
    type: yesno
    sql: ${TABLE}.bl


It looks like the actual variable to which the filter is supposed to be applied is being stripped out. Other types of templated filters work fine though

Extra Info: 1. I NEED TO USE TEMPLATED FILTERS The actual code will have the templated filter inside a “group by”, so other filtering methods are not feasible.
2. It’s obviously possible to work around this, but I’d like to avoid this if possible

(peter.whitehead) #2

Hi @lk_learn!

This is a known issue that the yesno filter will not populate in the generated sql. This issue has been fixed on Looker v 5.12. Please let us know if you have any other questions!