[Dbix-class] how to build this query? col1 not like "%xx%" AND col1 like "%yy%"

[Rajeev Prasad]

thanks Paul, very helpful. and to the point. I was able to chain resultset.




----- Original Message -----
From: Paul Findlay <Paul.Findlay at fonterra.com>
To: DBIx::Class user and developer list <dbix-class at lists.scsys.co.uk>
Cc: 
Sent: Tuesday, March 19, 2013 8:26 PM
Subject: RE: [Dbix-class] how to build this query? col1 not like "%xx%" AND col1 like "%yy%"

Hi Rajeev,

Not sure what you have tried, but this should work:

my $rs_1 = $rs->search({
    col1 => { -not_like => "%xx%", -like => "%yy%" }
});

Then to do extra searches on the result set, just call search again.

my $rs_2 = $rs_1->search({ col1 => { -not_like => '%zz%" }});

Documentation for chaining resultsets: https://metacpan.org/module/DBIx::Class::ResultSet#Chaining-resultsets

And on where clauses, look at the SQL::Abstract documentation:
"The main logic of this module is that things in arrays are OR'ed, and things in hashes are AND'ed."
https://metacpan.org/module/SQL::Abstract#WHERE-CLAUSES

- Paul

DISCLAIMER
This email contains information that is confidential and which may be legally privileged. If you have received this email in error, please notify the sender immediately and delete the email. This email is intended solely for the use of the intended recipient and you may not use or disclose this email in any way.

_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk