Annet,
Thanks for the response.
How do you handle sorting in the joined rows?
Thanks,
Cliff Kachinske
On Monday, July 23, 2012 1:37:03 AM UTC-4, Annet wrote:
>
> I solved a similar problem by adding a table which I called node. A node
> can either be a person or an organization. When I need a list of both
> people and organizations I use a left join for the tables person and
> organization. In the view I use:
>
> {{if row.person.last_name:}}
> {{=row.person.first_name}} {{=row.person.last_name}}
> {{elif row.organization.name:}}
> {{=row.organization.name}}
> {{pass}}
>
>
> Kind regards,
>
> Annet.
>
--