Create your own model. Subclass QSqlQueryModel and reimp QSqlQueryModel::data(). If role is Qt::MyMagicFoo1 then use e.g.

EDIT: where 0 is the column of foo1 sql position.

hi
Thanks for the replay but i didnt understand it .
in the data subclass method i did :

but it still show me in the result 3 columns , and only in the third the display
i dont what to display 3 columns only one

The way I see it, you have two options:

1. Just hide the columns you don’t want to see in the view. QTableView supports the hideColumn(int column) method for that.
2. Use a QSortFilterProxyModel to hide the columns you don’t want, by subclassing that class and reimplementing the filterAcceptsColumn method to return false for the columns you want to hide.

hi and thanks for the replay i tryed to use hideColumn but it didnt work

i want to avoid to add yet another model to the stack

You mean that even after calling hideColumn, it is still visible in your view?

yes , but i implementing the QSortFilterProxyModel now i hope it will work finally …

Well, that would be a bug in Qt. If you could create a minimal simple, self-contained example that has this behaviour, then please share that.

will do , it will take time to build complex GUI as sample . but i will

Please keep it as simple as possible when creating a sample. Less is more in these cases!

sure , by the way the filter proxy worked . thanks!

Hi but now i have another problem , in the proxy model
i set to filter the 2 first columns like this :

and in the PlayListMiniSqlModel ( its the QSqlQueryModel im using in the table)
when i try to get the display string of the hidden 2 columns i only get the 3 column .

where in the model i can get the hidden column data ?

im using QSortFilterProxyModel to filter column that im getting from QSqlQueryModel model but becose the filterAcceptsColumn method is const “all the way” i have problem to set Qt::UserRole data in the right index . how can i overcome this?

umen242 wrote:

Hi but now i have another problem , in the proxy model
i set to filter the 2 first columns like this :

1. bool PlayListMiniSortFilterProxyModel::filterAcceptsColumn(int source_column, const QModelIndex& index) const
2. {
3.  //qDebug() << "filterAcceptsColumn(): column = " << source_column ;
4.  if(source_column ==2)
5.   return QSortFilterProxyModel::filterAcceptsColumn(source_column,index);
6.  return false;
7. }

and in the PlayListMiniSqlModel ( its the QSqlQueryModel im using in the table)
when i try to get the display string of the hidden 2 columns i only get the 3 column .

1. QVariant PlayListMiniSqlModel::data(const QModelIndex &index, int role) const
2. {
3.      
4.  
5.   QVariant value;
6.  
7.   int c = index.column();  //HERE IT ONLY SHOW ME 2 , NEVER 0 and 1
8.   int r = index.row();
9.  
10.    value = QSqlQueryModel::data(index, role);
11.   QString s = value.toString();
12.   if(role == Qt::DisplayRole)
13.   {
14.   value = QSqlQueryModel::data(index, role);
15.   QString s = value.toString();
16.   }
17.  
18.   return value;
19. }

where in the model i can get the hidden column data ?

That sounds logical to me. The data() method will be called by the view or proxy model on top of the model. That object will (as much as possible) only query for the items it needs. In this case, that would be column 2, not column 0 or 1, as your proxy hides these. Why do you expect this method to be called for all cells, even the ones you’re not showing?

umen242 wrote:

im using QSortFilterProxyModel to filter column that im getting from QSqlQueryModel model but becose the filterAcceptsColumn method is const “all the way” i have problem to set Qt::UserRole data in the right index . how can i overcome this?

very simple , sorry im not native English speaker so the semantics are wrong (most of the time..).
what im trying to do is very simple ( very simple in the logic of it )
1. run sql query that returns 3 columns in each row (“select foo1,foo2,foo3 from tbl”)
2. use the data from column 1 and 2 ( concat the 2 strings )
3. set it to column 3 Qt::UserRole placeholder ( i need it for later use ) that in the end becomes the only row that is displayed
4 this is for each row / record that returns from the sql query