customized drop down filter

[dzimmerman]

is there a way to create a dropdown with 2 values Open or Closed. When open is selected only display those records with no date. If closed, display records with a date value

[Johnny Major]

You could add a column to your data source that checks if the date is null or not then use that column to filter on.

Data Source example - this table has a timestamp field so I'm converting it to a date.

case date(vvcts) WHEN '0001-01-01' THEN '0' ELSE '1' END AS hasdate,

Then add the filter for HASDATE and transform it to a dropdown. I used inline data for the drop down

Filter:
NAB Filter.png

Dropdown:
NAB filter dropdown.png

Grid "Not Filtered"
NAB Grid Not Filtered.png

Grid "Filtered Open"
NAB Grid Filtered Open.png

Grid "Filtered Closed"
NAB Grid Filtered Closed.png

[dzimmerman]

thanks let me try that :)

[dzimmerman]

this worked exactly as i needed. thanks!