How to filter QSqlRelationalTable?

[istdasklar]

When I do this :

model = new QSqlRelationalTableModel;
model->setTable("table");
tableView->setModel(model);
model->setFilter ("id = 660");

model = new QSqlRelationalTableModel;
model->setTable("table");
tableView->setModel(model);
model->setFilter ("id = 660");

To copy to clipboard, switch view to plain text mode 

IT's Works!


But when I do this :

model = new QSqlRelationalTableModel;
model->setTable("personne");
model->setRelation(3, QSqlRelation("status", "id", "nom"));
tableView->setItemDelegate(new QSqlRelationalDelegate(tableView));
tableView->setModel(model);
model->setFilter ("id = 660");

model = new QSqlRelationalTableModel;
model->setTable("personne");
model->setRelation(3, QSqlRelation("status", "id", "nom"));
tableView->setItemDelegate(new QSqlRelationalDelegate(tableView));
tableView->setModel(model);
model->setFilter ("id = 660");

To copy to clipboard, switch view to plain text mode 

It's doesn't work !! Why ?

[tranfuga25s]

Because you have to use the relationated filed name to filter...

model = new QSqlRelationalTableModel;
model->setTable("personne");
model->setRelation(3, QSqlRelation("status", "id", "nom"));
tableView->setItemDelegate(new QSqlRelationalDelegate(tableView));
tableView->setModel(model);
model->setFilter ("mon = *****");

model = new QSqlRelationalTableModel;
model->setTable("personne");
model->setRelation(3, QSqlRelation("status", "id", "nom"));
tableView->setItemDelegate(new QSqlRelationalDelegate(tableView));
tableView->setModel(model);
model->setFilter ("mon = *****");

To copy to clipboard, switch view to plain text mode 

Don`t now why, but seems to work that way...