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
Announcement
Collapse
No announcement yet.
customized drop down filter
Collapse
X
-
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.
Code:case date(vvcts) WHEN '0001-01-01' THEN '0' ELSE '1' END AS hasdate,
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
Comment