model->setEditStrategy(QSqlTableModel::OnManualSubmit) ;
model->setTable("people");
model->setFilter("name = 'tinashe'");
model->select();

ui->tableView->setModel(model);


I am trying to filter every name and only display " tinashe " I only get blank table view but when I substitute with
model->setFilter("ID = 1 );
IT WORKS WELL .

please assist where am I wrong