Quick tip! Boolean in SQL
How to get a boolean value with a SQL backend
Contents
Are you looking for a boolean column in SQL? Or have a virtual table and need a toggle/checkbox in your app?
If you have just a string/text field with True/False this wont work.
You need to convert the column in SQL to BIT.
Bit is an integer data type that can take a value of 0, 1, or NULL 1 for true, 0 for false.
Then reload/refresh your table into your dataverse/virtual table and it can be selected with a checkbox!