Author Topic: filtering for checkbox with null values  (Read 1483 times)

kshipra

  • Pro Enterprise
  • Jr. Member
  • *
  • Posts: 94
    • View Profile
filtering for checkbox with null values
« on: November 07, 2017, 11:19:23 am »
I have nullable boolean values in database and when shown in grid, checkbox is shown as unknown. How can I provide filtering ability for checkboxes with unknown text ? . I can filter only for true/ false or both. But would like to filter for unknowns.

Thanks

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6296
    • View Profile
Re: filtering for checkbox with null values
« Reply #1 on: November 07, 2017, 11:20:32 pm »
You would need a drop down filter in the header and custom filtering condition as in this example

https://paramquery.com/pro/demos/filter_custom