Filter contents of a QTableView connected to SQLite database via QSqlTableModel

Question

How can I filter the contents of a QTableView that is connected to a SQLite database via QSqlTableModel?

For example, if the database contains a "name" column, I want to show only the rows where the name is "Jack"?

If you want to show database content, the right way is to use `QTableView` with a model. Then you can search on the model using `QAbstractItemModel::match` or `QSortFilterProxyModel`. — Nejat, Jan 20 '15 at 04:29

score 3 · Answer 1 · edited Jun 20 '20 at 09:12

You can use QSqlTableModel::setFilter(). The filtering will be done by the model, and the view will automatically update itself to show only the filtered items.

The filter is a SQL WHERE clause without the keyword WHERE (for example, name='Josephine').

If the model is already populated with data from a database, the model re-selects it with the new filter. Otherwise, the filter will be applied the next time select() is called.

Filter contents of a QTableView connected to SQLite database via QSqlTableModel

1 Answers1