Show Value 0 or 1 when having a tinyInt column from Mysql on SearchBuilder

Pliachas Paschalis

Link to test case:
Debugger code (debug.datatables.net):
Error messages shown:
Description of problem: How can i show Value 0 or 1 when having a tinyInt column from Mysql on SearchBuilder. Now i select the field, next the condition, but on combobox when i open it there are three entries : Value, empty, empty. When i select each one of empty value the filter applies to data table.

colin

What kind of values does that field hold? Could you create a test case that demonstrates the issue please, it'll help us to understand the data values,

Colin

Pliachas Paschalis

this is the type on mysql: tinyint(1)

Pliachas Paschalis

Demonstration:
https://gaswoodalichanidis-gr.stackstaging.com/TestCase.php
In searchBuilder select IsCustomer field, condition Equals and see the values incombobox.
Thanks in advance

allan

Thank you for the link.

The problem is the input element that is being used for the display renderer for that column:

                        if (type === 'display') {
                            return '<input type="checkbox" class="editor-active">';

The select options can't show an input element, and SearchBuilder will use the display value by default, hence the issue.

You workaround this, you need to use the orthogonal data options. See this example.

Allan

Pliachas Paschalis

Thanks Allan that worked. Sorry for the delay.