DMZ 1.7.1 (DataMapper OverZealous Edition)

[eluser]OverZealous[/eluser]
@introvert
Well, you are doing it wrong. If you read the docs, you'll see that get_sql wipes out the current query. If you want to see the generated query, then you should use check_last_query, as outlined in the troubleshooting page of the manual.

Everything that DMZ is doing is exactly what you asked it to do.


@Tom Vogt
You said that an asset only belongs to one user, correct? then why not simply do:

Code:

$asset->item->get();

That's all items associated with that asset. Since there's only one user per asset, there's no reason to make it more complicated.


@happydude
There's an entire section in the manual on join fields. Please spend some time reading that.