DataMapper ORM v1.8.2

[eluser]WanWizard[/eluser]
[quote author="Spir" date="1327575356"]How would you sort by a join field value? Is that possible?[/quote]
Looking at the code, the DM version of order_by() always prefixes the field with the current table name, unless it is already prefixed.

So ordering on a field in a join table should be possible if you prefix it with the alias of the join table.

You could work around it by replacing the order_by() method by

Code:

public function order_by($orderby, $direction = '', $escape = TRUE)
{
$escape and $orderby = $this->add_table_name($orderby);
$this->db->order_by($orderby, $direction);

// For method chaining
return $this;
}

And then pass FALSE as third parameter if you don't want to prefix the field with the table name.

If this works for you, let me know and I'll add it to the next release.