Filtering QSqlRelation in QSqlRelationalTableModel

Question

I have two tables like: Person (Id, Name, JobID, Age) Jobs (Id, Company, Salary)

I'm using a SqlRelationalTableModel and it's working with the following QSqlRelation:

   model-> setTable("Person")
   model-> setRelation(2,QSqlRelation("Jobs", "Id", "Company"))

My problem is that now I want to show only the jobs with salaries over 50000 and I don't know how to filter Jobs table to do it since setFilter only affects Person table.

mugiseyebrows · Accepted Answer · 2020-12-23 18:27:28Z

0

You can use QSqlQueryModel

QSqlQueryModel* model = new QSqlQueryModel();
model->setQuery("select * from Person left join Jobs on Person.JobID=Jobs.Id where Salary>50000");

answered Dec 23, 2020 at 18:27

mugiseyebrows

4,9491 gold badge16 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Muslimbek Abduganiev Over a year ago

What if I still need to support updates on the table?

Collectives™ on Stack Overflow

Filtering QSqlRelation in QSqlRelationalTableModel

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related