• If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Announcement

Collapse
No announcement yet.

customized drop down filter

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • customized drop down filter

    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

  • #2
    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,
    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

    Comment


    • #3
      thanks let me try that :)

      Comment


      • #4
        this worked exactly as i needed. thanks!

        Comment

        Working...
        X