Using liquid parameters in SQL breaks filter suggestions

[OmarS]

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.  

[yadderace]

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.

[OmarS]

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