Sorting columns of the QTableView

[Qiieha]

Hi all. I need your help please...
I have a QTableView and use the QSqlQueryModel and the QItemSelectionModel to handle the data. Now I want to enable sorting by clicking on the header. I can enable sorting at the TableView, but the sort method desn't work.

Does anybody knows how I can sort my QTableView with less effort. I don't want to use the QTableWidget. It would be great, if that works.

[MarekR22]

By default model doesn't know how to sort data in effective way, you have to implement it by overriding QAbstractItemModel::sort.

Edit: sorry, there is easy solution. Just replace QSqlQueryModel with QSqlTableModel, there is sort method already implemented. You have to just enable sorting in table QTableView::sortingEnabled.

[Qiieha]

Ok, thank u for your help, but I want to use the setQuery method. And if I use QSqlTableModel this Method isn't available(protected). And the documentation say, that setQuery shouldn't be used.

Do you know a solution?

[MarekR22]

Which setQuery do you use? Note that void QSqlQueryModel::setQuery(const QString &query, const QSqlDatabase &db = QSqlDatabase()) is still public, only void QSqlQueryModel::setQuery(const QSqlQuery &query) is protected.

[Qiieha]

Unfortunately QSqlTableModel has only one setQuery() method and it is this one: QSqlQueryModel::setQuery(const QSqlQuery &query).

What can I do?

[MarekR22]

Nope! You are wrong!
QSqlTableModel inharits form QSqlQueryModel. One version of setQuery is repated in QSqlTableModel to make it protected for some reason. Second version is still public and you can and should use it.

[Qiieha]

I tried to make that and know that there are two versions, but the compiler doesn't offer the possibility to use it

[Qiieha]

Does anybody know why???

[spawn9997]

This has been asked a lot and it seems there is no easy or direct answer. HERE

It seems implementing your own model is the best bet. I prefer sorting via proxy (QSortFilterProxyModel) but DB access speed can make large models sort slowly.

spawn9997