Important: Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct
QSqlTableModel - filter not working?
joe4 last edited by
I created a QSqlTableModel, set a filter and used a QTableView to show a table of my filtered data. This works as expected...
model = new QSqlTableModel; model->setTable("XXX"); model->select(); model->setFilter(filter); table = new QTableView; table->setModel(model);
However, when I try to compute the sum of all visible values of a column in the table view...
float sum = 0.0f; for(int i=0;i<model->rowCount();i++) sum += model->record(i).value("amount").toFloat();
... I get the sum of ALL entries in the table model, NOT only of those items visible in the TableView (where the filter is applied).
How can I make my sum()-function to compute the sum of only those values which are visible in the TableView?
Thank you for your answers!