Answers

• sandy Posts: 913Questions: 0Answers: 236

  November 2020

  Hi @GerritKuilder ,

  SearchBuilder ships as standard with conditions for all of the columns.type that DataTables is able to auto detect. Boolean is not one of these types.

  It is however possible to declare your own conditions for a custom type, take a look at this example. For a boolean column type you would do something like this...

  $.fn.dataTable.ext.searchBuilder.conditions.boolean = {
      'true': {
          conditionName: function (dt, i18n) { return 'True'; },
          isInputValid: function () { return true; },
          init: function () { return; },
          inputValue: function () { return; },
          search: function (value) { return value === 'true'; },
      },
      'false': {
          conditionName: function (dt, i18n) { return 'False'; },
          isInputValid: function () { return false; },
          init: function () { return; },
          inputValue: function () { return; },
          search: function (value) { return value === 'false'; },
      },
  }
  

  ...as well as setting a custom column type of boolean.

  BUT, you are using icons as the boolean values, so the above will not work for that use case. We've had a brief chat about this and we think that we need to add an orthogonal option to SearchBuilder, a bit like SearchPanes does with columns.searchpanes.orthogonal. I've raised an issue internally (DD-1727 for my reference) and will report back here when there is an update.

  In the mean time I suppose there are one or two hacky ways that you could solve this until we get a proper fix. The two obvious paths forwards that I can see would be to either add a hidden column, with simple true/false string values that SearchBuilder can filter on. The second would be to see what the value of value is in the search function above. It may be that you can filter using that.

  Thanks,
  Sandy
• GerritKuilder Posts: 7Questions: 2Answers: 0

  November 2020

  Hi @sandy ,

  thank you for your answer, I ended up at that table a few times but could not see how it would apply to boolean values. I looked a bit closer and think I can figure it by now.
  I will see if I can implement it over the coming few days and will let you know.
  I think a boolean column type would be most welcome. if a td class or value="" can be used for picking up the value the output in the column can be very flexible.

  Kind regards,

  Gerrit Kuilder
• sandy Posts: 913Questions: 0Answers: 236

  November 2020 Answer ✓

  Hi @GerritKuilder ,

  Just to let you know that we have now added an orthogonal option to SearchBuilder. This will be available in the next SearchBuilder release which we hope will be in the next few weeks. Until then you can access the fix from the nightly builds.

  Take a look at this example to see a couple of ways it may work.

  Thanks,
  Sandy
• GerritKuilder Posts: 7Questions: 2Answers: 0

  November 2020

  Hi Sandy

  Thank you,

  bookmarked this link and will check back in a few weeks, busy with other projects now.

  Kind Regards,

  Gerrit Kuilder