Using liquid parameters in SQL breaks filter suggestions

Looker Q&A Looker
1

Hello,

I am writing custom SQL to define my table in Looker and I’m trying to filter date within the look using liquid parameters like this:

WHERE TO_DATE(ORDER_CREATED_AT) BETWEEN TO_DATE({% parameter StartDate %}) AND  TO_DATE({% parameter EndDate %})

This is one of the parameters:

  parameter: StartDate {
    type: date
    convert_tz: no
  }

The problem is after I included this line, the filter suggestions for my other fields stopped showing. I went through looker documentation hoping to find a fix with no luck. If anyone can help with this it would be greatly appreciated.

2

Hi @OmarS , currently I made something similar with a derived table, but I used “filter” instead “parameter”.

Here is my view where I defined my derived table:

And here is my dim_date view where I defined my filter:

Maybe you can apply something similar.

1 Like
3

Thanks for the reply! I will give that a shot right now.

4

@OmarS - did it work for you. I’m gonna try this suggestion from @yadderace