[Dbix-class] How to search records with "IS NOT NULL"

Ramprabhu Kaliaperumal ramprabhu.kaliaperumal at oracle.com
Tue Jul 24 17:45:51 GMT 2007

Hi All

I want something like 'SELECT * FROM employee WHERE department IS NOT NULL'

I tried $schema->resultset('employee')->search({ department => {"IS" => 
"NOT NULL"}});

But it is not working...

Any help?


More information about the Dbix-class mailing list