QSortFilterProxyModel nothing changes

[unix7777]

Hi i'm trying to filter the content displayed in the TableView getting the string from lineEdit but nothing happens when i write in the lineEdit.
HELP

QString searchValue = ui->lineEdit_search_clients->text();
 
        QSqlQueryModel *model=new QSqlQueryModel();
 
        QSortFilterProxyModel *proxyModel = new QSortFilterProxyModel;
        proxyModel->setSourceModel(model);
        proxyModel->setFilterRegExp(QRegExp(searchValue, Qt::CaseInsensitive, QRegExp::FixedString));
 
        model->setQuery("SELECT ROWID, ClientName, ClientCity, ClientEik FROM clients");
        model->setHeaderData(0, Qt::Horizontal, QObject::tr("RowID"));
        model->setHeaderData(1, Qt::Horizontal, QObject::tr("Name"));
        model->setHeaderData(2, Qt::Horizontal, QObject::tr("City"));
        model->setHeaderData(3, Qt::Horizontal, QObject::tr("ID"));
 
 
        ui->tableView_clients->setModel(proxyModel);
        ui->tableView_clients->setSortingEnabled(true);
        ui->tableView_clients->setColumnWidth(0,30);
        ui->tableView_clients->setColumnWidth(1,170);
        ui->tableView_clients->setColumnWidth(2,100);
        ui->tableView_clients->setColumnWidth(3,70);
        ui->tableView_clients->horizontalHeader()->setResizeMode(QHeaderView::Interactive);
        ui->tableView_clients->horizontalHeader()->setStretchLastSection(true);
        ui->tableView_clients->show();

QString searchValue = ui->lineEdit_search_clients->text();

        QSqlQueryModel *model=new QSqlQueryModel();

        QSortFilterProxyModel *proxyModel = new QSortFilterProxyModel;
        proxyModel->setSourceModel(model);
        proxyModel->setFilterRegExp(QRegExp(searchValue, Qt::CaseInsensitive, QRegExp::FixedString));

        model->setQuery("SELECT ROWID, ClientName, ClientCity, ClientEik FROM clients");
        model->setHeaderData(0, Qt::Horizontal, QObject::tr("RowID"));
        model->setHeaderData(1, Qt::Horizontal, QObject::tr("Name"));
        model->setHeaderData(2, Qt::Horizontal, QObject::tr("City"));
        model->setHeaderData(3, Qt::Horizontal, QObject::tr("ID"));


        ui->tableView_clients->setModel(proxyModel);
        ui->tableView_clients->setSortingEnabled(true);
        ui->tableView_clients->setColumnWidth(0,30);
        ui->tableView_clients->setColumnWidth(1,170);
        ui->tableView_clients->setColumnWidth(2,100);
        ui->tableView_clients->setColumnWidth(3,70);
        ui->tableView_clients->horizontalHeader()->setResizeMode(QHeaderView::Interactive);
        ui->tableView_clients->horizontalHeader()->setStretchLastSection(true);
        ui->tableView_clients->show();

To copy to clipboard, switch view to plain text mode 

[yeye_olive]

If you write in lineEdit after this code has been run then it will not change anything. You have to call setFilterRegExp() again (or, better yet, setFilterFixedString() in your case) after the lineEdit's text has been modified. Also remember that QSortFilterProxyModel filters column 0 of the model by default, which may or may not be what you want.

By the way your code leaks memory in two places.

[unix7777]

Thanks, now the code looks like this:

QString searchValue = ui->lineEdit_search_clients->text();
        QSqlQueryModel *model=new QSqlQueryModel(this);
        QSortFilterProxyModel *proxyModel = new QSortFilterProxyModel(this);
 
        proxyModel->setSourceModel(model);
        proxyModel->setFilterRegExp(QRegExp(searchValue, Qt::CaseInsensitive, QRegExp::FixedString));
 
        connect(ui->lineEdit_search_clients, SIGNAL(textChanged(QString)),
                    proxyModel, SLOT(setFilterFixedString(QString)));
 
        model->setQuery("SELECT ROWID, ClientName, ClientCity, ClientEik FROM clients");
        model->setHeaderData(0, Qt::Horizontal, QObject::tr("RowID"));
        model->setHeaderData(1, Qt::Horizontal, QObject::tr("Name"));
        model->setHeaderData(2, Qt::Horizontal, QObject::tr("City"));
        model->setHeaderData(3, Qt::Horizontal, QObject::tr("ID"));
 
 
        ui->tableView_clients->setModel(proxyModel);
        ui->tableView_clients->setSortingEnabled(true);
        ui->tableView_clients->setColumnWidth(0,30);
        ui->tableView_clients->setColumnWidth(1,170);
        ui->tableView_clients->setColumnWidth(2,100);
        ui->tableView_clients->setColumnWidth(3,70);
        ui->tableView_clients->horizontalHeader()->setResizeMode(QHeaderView::Interactive);
        ui->tableView_clients->horizontalHeader()->setStretchLastSection(true);
        ui->tableView_clients->show();

QString searchValue = ui->lineEdit_search_clients->text();
        QSqlQueryModel *model=new QSqlQueryModel(this);
        QSortFilterProxyModel *proxyModel = new QSortFilterProxyModel(this);

        proxyModel->setSourceModel(model);
        proxyModel->setFilterRegExp(QRegExp(searchValue, Qt::CaseInsensitive, QRegExp::FixedString));

        connect(ui->lineEdit_search_clients, SIGNAL(textChanged(QString)),
                    proxyModel, SLOT(setFilterFixedString(QString)));

        model->setQuery("SELECT ROWID, ClientName, ClientCity, ClientEik FROM clients");
        model->setHeaderData(0, Qt::Horizontal, QObject::tr("RowID"));
        model->setHeaderData(1, Qt::Horizontal, QObject::tr("Name"));
        model->setHeaderData(2, Qt::Horizontal, QObject::tr("City"));
        model->setHeaderData(3, Qt::Horizontal, QObject::tr("ID"));


        ui->tableView_clients->setModel(proxyModel);
        ui->tableView_clients->setSortingEnabled(true);
        ui->tableView_clients->setColumnWidth(0,30);
        ui->tableView_clients->setColumnWidth(1,170);
        ui->tableView_clients->setColumnWidth(2,100);
        ui->tableView_clients->setColumnWidth(3,70);
        ui->tableView_clients->horizontalHeader()->setResizeMode(QHeaderView::Interactive);
        ui->tableView_clients->horizontalHeader()->setStretchLastSection(true);
        ui->tableView_clients->show();

To copy to clipboard, switch view to plain text mode 

Remain the problem with filtering not only first column but everywhere.Any suggestions?

[yeye_olive]

QSortFilterProxyModel has a method to select which column to filter: either a specific one or all of them.

[unix7777]

sorry , but i can't figure out how to filter ALL without subclassing!

[ecanela]

add the code

proxymodel->setFilterKeyColumn ( -1 )

proxymodel->setFilterKeyColumn ( -1 )

To copy to clipboard, switch view to plain text mode 

the -1 indicate read the value in all the column.