QSqlQueryModel needs filtering data - HOWTO

[MarkoSan]

You've already mentioned both your options:

1) filter on SQL level by using changing the query of the model that is shown in ProductsView

2) filter in a proxy model that sits between the SQL model and the view.
Either by filtering on a value in one of the columns of the source model or, if a more complex decision is necessary, by deriving and implementing filterAcceptsRow()

I would go for (1)

Cheers,
_

Did that, works ok!