[Deprecated] DMZ 1.5.4 (DataMapper OverZealous Edition)

[eluser]bEz[/eluser]
By golly, I think I've got'it! :bug:

Code:

$registrations = new Registration();
$registrations->Distinct()   // Distinct() is not necessary, but I recall seeing it as an advised note in the DMZ Manual
  ->where_related('obj2/obj8/obj4', 'field1', 'VALUE')
  ->include_related('obj3', array('field2', 'field6'))
  ->include_related('obj5', array('field2'));

// Here is where I used AR methods (the key was to provide the fully qualified name of the db.table)
$registrations->db
  ->select('users.username As attendee')
  ->from('otherdb.users as users', 'users.user_id = registrations.user_id');

$registrations->get();

I was then able to loop as usual and

Code:

echo $r->attendee

using object notation.

The funny thing is that I've read other posts in this thread talking about the limited examples in the manual.
I think my problem was that I assumed my issue was on the abstract side, when in reality it was closer to the example provided (just thrown off on how to do a selection from another database).

I can now tuck away the $object->query($sql) until absolute need (which for now I don't see in the near future, **COUGH** 1.6 or eventually 2.0 )