Allow 'Not equal to' as operator for boolean fields in Ad-hoc Query

Please allow 'Not equal to' as an operator for boolean fields in Ad-hoc Query.  This would allow us to compare two boolean fields to see if they were not the same and would allow us to check whether a field was anything other than True, e.g., False or blank.  Both of these are real life examples.  At the moment we have to build subqueries to do these sorts of comparisons, or sometimes just export the data and do the comparison in Excel, which is hardly best practice.

  • Guest
  • Oct 29 2018
Organization Name (Please enter full organization name) The Wilderness Society Ltd (Australia)
Reported Version 4.0
  • Attach files