DataMapper - how to perform basic query

[eluser]Genki1[/eluser]
And, to assist others, the solution provided above is the shorthand for this:

Code:

$u->setting->where('name', 'has_allowed');  // filter the related table "settings"
$u->setting->include_join_fields();  // include columns from the join table in the result set
$u->setting->get();                  // perform the query
echo $u->setting->join_value;        // display the field "value" from the join table