[FIXED] filterring on IS NOT NULL using QSqlTableModel::setFilter(const QString &filter)

Issue

If I'd like to filter on the IS NOT NULL condition using QSqlTableModel::setFilter(const QString &filter), what filter syntax should I pass to the method ?

Solution

From the docs:

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

So an appropriate filter with IS NOT NULL would resemble

mySqlTableModel.setFilter("id IS NOT NULL");

Answered By - TrebledJ