Boolean Display in QTableView [Solved]

[Kaptain Karl]

I'm using a QTableView to display data in a QSqlRelationalTableModel from two related database tables. One of the tables contains a boolean field. I'd like this to display the word "True" or "False" rather than 1 or 0. The RDBMS is MySQL which stores booleans as tiny integers.

I know I could get around this by altering the database to use a string field rather than a boolean field and just store "true" and "false" but that seems wasteful.

How would I go about this?

[dkruger]

I'm not sure what the recommended way would be, but I can think of two straight-forward ways off the top of my head.

Create an inherited model and override the QAbstractItemModel::data() function. Have it return "True" or "False" for the Qt::DisplayRole of the column in question.

Create a custom QItemDelegate for that column/table which renders the boolean field to "True" or "False". You can assign it with QAbstractItemView::setItemDelegateForColumn() or QAbstractItemView::setItemDelegate().

[SGaist]

Hi and welcome to devnet,

A third way would be to use a "QIdentityProxyModel":http://qt-project.org/doc/qt-4.8/qidentityproxymodel.html in a similar fashion as 1. suggested by dkruger

Hope it helps

[Kaptain Karl]

I went the QItemDelegate solution. Mostly because I could wrap my head around it the best. Thanks for the suggestions.
Karl

[SGaist]

You're welcome !

Don't forget to update the thread's title to solved so other forum users will know that it's all good :)