How to choose which columns to display and in which order when using QSqlRelationalTableModel?

[jdent]

I have a QSqlRelationalTableModel but there is no way to select which columns to display and in what order...
If I replace it with a query string then I lose the setRelation() functionality which is very valuable to me
How can I specify which columns I want to display and still have the setRelation() functionality?

Thanks!

[JonB]

@jdent

but I don't'see a method moveColumn()

bool QAbstractItemModel::moveColumn(const QModelIndex &sourceParent, int sourceColumn, const QModelIndex &destinationParent, int destinationChild)

But (and I see @SGaist has just posted) you don't want to move columns around in the model to change the order they are displayed. You do this in the view, the QHeaderView which is the QTableView::horizontalHeader() , by moving its sections.

[JonB]

@jdent
I don't understand. A QSqlRelationalTableModel is a QSqlTableModel just with additional "look up" of column(s) in other table(s) for display and editing purposes.

It is not about mapping to another table and then being able to pick arbitrary rows or columns there, your own JOINs etc., which I think you might be thinking about.

Per your other question, again I think you're hoping for too much from the base QSql classes. I came from MS .NET data classes, they offered a lot more if you're looking for DataSet-level stuff,

[SGaist]

Hi,

That's the kind of things you do at the QTableView and/or QHeaderView level.

[jdent]

@JonB Yes I am expecting much more. One question then: how can I move columns in a QTableView? How can I hide columns in a QTableView?

[SGaist]

@jdent please read the classes documentation I linked.

[jdent]

@SGaist There is a protected slot for columnMoved but I don't'see a method moveColumn()
Can you please orient me more specifically?

[SGaist]

@jdent QHeaderView::moveSection

[JonB]

@jdent

but I don't'see a method moveColumn()

bool QAbstractItemModel::moveColumn(const QModelIndex &sourceParent, int sourceColumn, const QModelIndex &destinationParent, int destinationChild)

But (and I see @SGaist has just posted) you don't want to move columns around in the model to change the order they are displayed. You do this in the view, the QHeaderView which is the QTableView::horizontalHeader() , by moving its sections.