I would like to get a table in the administration which i have the invoices pending from a date
so I create a class with _prepareCollection () function.
In the function I added this statement:
$now = Zend_Date::now(); $collection->addAttributeToFilter('dunning_payable_due_on',array('date' => true, 'to' => $now)); $collection->addAttributeToFilter('state','1');
but I get an error:
Integrity constraint violation: 1052 Column 'state' in where clause is ambiguous
I have to do a join but I don't know with what table.
thanks for your help.