[Deprecated] DMZ 1.5.3 (DataMapper OverZealous Edition)

[eluser]OverZealous[/eluser]
Well, it shouldn't be doing that. I'm not sure why it would, because the part of the code that adds a table adds it as long as there is a parent relationship, and the field part of the where doesn't include a "." or a "(".

If you want to force adding the table, there's three ways:

1) Try reversing the query order, which might force it to add:

Code:

$p = $c->product->join_related('category',array('name'))->where('enabled',1)->get();

2) Just type it in:

Code:

$c->product->where('cl_products.enabled',1)

3) If you want to do it "correctly", DMZ includes a function called add_table_name, which is what where uses:

Code:

$product = $c->product;
$product->where($product->add_table_name('enabled'), 1)

Which you choose between 2 and 3 depends on personal preference.