Hide rows from QTableView/QSqlRelationalTableModel

[jiveaxe]

Hi,
I have created a tableview which uses as model a QSqlRelationalTableModel and then some buttons for adding and removing records. All works good.

When I run the program the table shows all records. Is it possible to hide some rows (for example rows with a field different from a given one) and still have a working add/remove record functions (with primary key)?

Thanks

[jiveaxe]

I'm trying this approach: to use QSqlRecord QSqlQueryModel::record(int row) in a for loop to check each row in the table; from each row I got the content of the desired field using QVariant QSqlRecord::value(int index).

Well, this in theory because with the code below I have an empty value returned from QSqlRecord::value() and so comparison fails

for(int i = 0; i < numRows; i++) {
    record = ((QSqlRelationalTableModel*)ui->scoopsTableView->model())->record(i);
    if(record.value(field) != ui->articleComboBox->itemData(ui->articleComboBox->currentIndex()))
        ui->scoopsTableView->hideRow(i);
}

for(int i = 0; i < numRows; i++) {
    record = ((QSqlRelationalTableModel*)ui->scoopsTableView->model())->record(i);
    if(record.value(field) != ui->articleComboBox->itemData(ui->articleComboBox->currentIndex()))
        ui->scoopsTableView->hideRow(i);
}

To copy to clipboard, switch view to plain text mode 

Where is my error?

[Lesiok]

Why not to use QSqlTableModel::setFilter ?

[jiveaxe]

Very thanks, Lesiok. It worked fine.