A Question regarding QSortFilterProxyModel

[Pluvius]

Hello guys!

Whenever I retrieve a row from a QSqlTableModel the output on the view is naturally like this:
ss1.png

I would like to "customize" the way data is displayed like in the following image:

Sans titre.png

At first I had a wild idea of subclassing a QTableView but my guess is to manipulate the QModelIndexes and map them to new ones in the QSortFilterProxyModel but I'm not sure if this is the way to go, could you please help me on this one?

Thanks!

[Lykurg]

You could go for a QTreeView with a custom model (or use QSortFilterProxyModel) or provide a custom delegate, which fakes the view you like.

[Pluvius]

This is very helpful thanks! I'll try to come up with a solution based off your suggestions

[Pluvius]

Hello Again!

Just wanted to give a quick update; I chose to implement a custom model, subclassing naturally QAbstractTableModel, and since it's read-only, I've had just four methods; rowcount, colmuncount, headerData, but the problem is with Data() method, here's what I did:

QVariant CustomModel::data( const QModelIndex &index, int role ) const
{
   QString name;
    QSqlQuery q("select name from employee where id=3");
    while (q.next()) {
    QVariant resultat = q.value(0);
    name = resultat.toString();
    }
 
switch( role )
{
 
case Qt::DisplayRole:
 
    if (index.column()==1 && index.row()==2)
        return name;
 
default:
 
    return QVariant();
}
}

QVariant CustomModel::data( const QModelIndex &index, int role ) const
{
   QString name;
    QSqlQuery q("select name from employee where id=3");
    while (q.next()) {
    QVariant resultat = q.value(0);
    name = resultat.toString();
    }

switch( role )
{

case Qt::DisplayRole:

    if (index.column()==1 && index.row()==2)
        return name;

default:

    return QVariant();
}
}

To copy to clipboard, switch view to plain text mode 

This works as I can display the data right where I want it to, but I'm not sure if this is the right way to go, any opinions?

Thanks