Display a string in a QTableView but sort using an associated integer value

[karn862]

Hi everyone,

I'm using a QAbstractTableModel and a QSortFilterProxyModel with a tableview like this :

MyTableModel *model = new MyTableModel(searcher);
MyQSortFilterProxyModel *proxyModel = new MyQSortFilterProxyModel();
proxyModel->setSourceModel(model);
ui->tableView->setModel(proxyModel);

MyTableModel *model = new MyTableModel(searcher);
MyQSortFilterProxyModel *proxyModel = new MyQSortFilterProxyModel();
proxyModel->setSourceModel(model);
ui->tableView->setModel(proxyModel);

To copy to clipboard, switch view to plain text mode 

When i click on a column header it is sorted but it's using the default comparison operator of the types used in the model.
I have a field representing an age in number of days but i display it in the tableview like "2 years".
I'm trying to get the proxy model to sort this column using the integer value and the tableview to display it using its string representation.

What would be the easiest way to obtain this behavior ?

Thank you.