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

[Ramprabhu Kaliaperumal]

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?

Thanks
-Ram