Show Value 0 or 1 when having a tinyInt column from Mysql on SearchBuilder
Show Value 0 or 1 when having a tinyInt column from Mysql on SearchBuilder
Pliachas Paschalis
Posts: 62Questions: 12Answers: 1
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.
This question has an accepted answers - jump to answer
Answers
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
this is the type on mysql: tinyint(1)
Demonstration:
https://gaswoodalichanidis-gr.stackstaging.com/TestCase.php
In searchBuilder select IsCustomer field, condition Equals and see the values incombobox.
Thanks in advance
Thank you for the link.
The problem is the
inputelement that is being used for the display renderer for that column:The
selectoptions 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
Thanks Allan that worked. Sorry for the delay.