Sorting Tree items based on database properties

[jnk5y]

Hello all,

Lets suppose I have a database table called people filled with names and addresses. I fill a qTreeWidget by doing

QTreeWidgetItem* peopleNode;
treeWidget->addTopLevelItem( peopleNode );
 
query.exec( "SELECT first_name FROM people;" );
while( query.next() ) {
QTreeWidgetItem* PeopleList = new QTreeWidgetItem(peopleNode);
PeopleList->setText( 0, query.value(0).toString() );
}

QTreeWidgetItem* peopleNode;
treeWidget->addTopLevelItem( peopleNode );

query.exec( "SELECT first_name FROM people;" );
while( query.next() ) {
QTreeWidgetItem* PeopleList = new QTreeWidgetItem(peopleNode);
PeopleList->setText( 0, query.value(0).toString() );
}

To copy to clipboard, switch view to plain text mode 

I would like to be able to right click on the peopleNode or items within and have a "sort by" menu which would list all the table columns and then sort the Node by that column.

Can anyone see a way of doing this

[wysota]

You need a sort-filter proxy model and a context menu for the view.

[jnk5y]

I'm sorry but I am not familiar with sort-filter proxy model. Could you explain it in further detail?

[wysota]

Take a look at QSortFilterProxyModel.