[odb-users] Problem building query with multiple shared objects

[Boris Kolpackov]

Hi Quentin,

Quentin Deldycke <quentindeldycke at gmail.com> writes:

> odb::query<C> qry(odb::query<C>::objb->obja->valuea == "Test");

ODB only supports one level of indirection in object queries. If
you need to do several levels, then you will have to use a view.
Views allow you to create an arbitrary-long custom JOIN chain
based on object relationships:

#pragma db view object(C) object(B) object(A)
struct C_View
{
  ...
};

odb::query<C_View> qry(odb::query<C_View>::A::valuea == "Test");

Boris