Problem using DateRangeInputComponent and CCC Bar Chart on CDE Dashboard

[okluge]

Maybe someone can help with the following problem. I'm trying display a ccc bar chart where the date range is defined by a DateRangeInputComponent.

Therefore I created 2 parameters "date_from" and "date_to" as listeners to the DRIComponent. I also put them as Parameters in the Bar Chart

My data source query for the chart looks something like this:

SELECT sales, count(employee_sales) as active   FROM table
  WHERE status = ''something"
  AND contract_date BETWEEN ${date_from} and ${date_to}

When I put in a fixed date the chart works fine, put when I use the parameters I always get a "no data found" message. What am I missing here?

[pmalves]

We always work with strings. If your contract_date is actually a date, try changing the query so that you cast it to string

[okluge]

thanks for your answer Pedro, works like a charm :-)