|Welcome to the Monastery|
Re^5: Problems Using Join in DBIx::Classby 1nickt (Abbot)
|on Dec 29, 2017 at 04:26 UTC||Need Help??|
Hi, as soonix and poj have said your query appears to be wrong, or not doing what you say you want. A sent_email date of '0000-00-00', which you do not want, will match IS NOT NULL in the first conditional and thus be returned.
You cannot have a query using one column with 2 different values, unless you use an OR
That's not correct. You use an arrayref, but the first element must be a modifier, e.g. -and.
I would say you need the following rather simpler construct:
Demonstrated with SQL::Abstract (which is used internally by DBIx::Class):
Hope this helps!
The way forward always starts with a minimal test.