How to change row or cell color in TableView with SqlQueryModel

[JonB]

@SGaist That sounds more like it! :)

[JonB]

@SGaist
Without changing to a table or other model, can't @Mucip change cell color just by overriding QSqlQueryModel::data() and dealing with Qt::BackgroundRole case with desired code, assuming that is indeed what he wants?

[SGaist]

That's another possibility yes. One thing to take into account is that if these customisation were to be "view specific", changing the base model would "propagate" them to all views showing the model data. The QIdentityProxyModel allows for more fine grained control in that regard.

[Mucip]

Dear @SGaist ,
I just want to show data not to modify. This is enaugh for me...

Regards,
Mucip:)

[Mucip]

Hi @JonB,
Yes. Just want to show data and change color of the desired rows.

Regards,
Mucip:)

[Mucip]

Dear @JonB,
Sonds good... Any sample about this?...

Regards,
Mucip:)

[SGaist]

What kind of sample are you looking for ?

[Mucip]

Dear @SGaist ,
You suggested QIdentityProxyModel. Is there any explenation or sample how to use this?
Regards,
Mucip:)

[SGaist]

Right in the documentation for the class that I already linked to earlier.

[VRonin]

You can use the RoleMaskProxyModel of this library.
I'm working on merging this into Qt 5.13: https://codereview.qt-project.org/245572 (at the time of writing it's marked as draft so private)

[JonB]

@Mucip said in How to change row or cell color in TableView with SqlQueryModel:

Hi @JonB,
Yes. Just want to show data and change color of the desired rows.

Regards,
Mucip:)

Sorry, I have been away for a few days. As I wrote earlier, if all you want to do is set background color of certain rows you could skip proxy models and just override QSqlQueryModel::data() to deal with Qt::BackgroundRole. It depends whether you can figure the color you want for whatever rows very simply in code, or whether you need something more sophisticated which a proxy model could provide.