[odb-users] Query a many-to-many relationship

[Boris Kolpackov]

Hi Dieter,

dieter.govaerts at bricsys.com <dieter.govaerts at bricsys.com> writes:

> I wanted to query employees based on the name of the _projects_ they
> work on, not its employers name.

Yes, you are right. Sorry, it was a long day.

Here is an object loading view example that should do the trick:

#pragma db view object(employee) object(project)
struct employee_projects
{
  std::shared_ptr<employee> e;
};

typedef odb::query<employee_projects> query;
 
db.query<employee_projects> (query::project::name == "Complex Hardware");

Boris