thanks Paul, very helpful. and to the point. I was able to chain resultset.
- Original Message -
From: Paul Findlay paul.find...@fonterra.com
To: DBIx::Class user and developer list dbix-class@lists.scsys.co.uk
Cc:
Sent: Tuesday, March 19, 2013 8:26 PM
Subject: RE: [Dbix-class] how to
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