Best way to implement full boolean data type support (SearchBuilder, server-side processing)

Best way to implement full boolean data type support (SearchBuilder, server-side processing)

supermindsupermind Posts: 23Questions: 3Answers: 0

DataTables and Editor supports date, string and num data types natively (+ formatted/html). We have lot of boolean fields in our application and few of them are nullable. I did not find any helpful discussion about implementing full boolean data type support including SearchBuilder and server side processing.

We format all true values as 'Yes' and false values as 'No', which works great. Editing values inline just by typing in 1, True, 0 or False goes smoothly and even null handling in saving works quite well when saving empty value.

However, using SearchBuilder to show only null values, 0 AND nulls or 1 AND nulls does not work at all. What we need is basicly three choises in selections: 'Yes', 'No' and 'Empty'. Is there somebody who have implemented something like that?

Sign In or Register to comment.