[Dbix-class] Refining Resultset

[Johannes Kilian]

Hi,

I'm learning to use DBIC correctly, but cannot figure out how to do the following: I've got a resultset from a previous search. Now I want to make further refinements on this resultset, doing something like this:

"Take current resultset and remove all items, whose attribute "A" does not fit a given pattern (best: given by RegEx or SQL-LIKE Expression)"

Pseudocode:

my $newRS = $RS->search('A' => {not => {'.*pattern.*'}});


Remarks:
 * It has to be a pattern (either RegEx or SQL LIKE-Expression)
 * It's not possible to define the "negative" pattern ("SELECT ALL WHERE "A" LIKE INVPattern ... is not possible ...)

Any idea how to do this?

Tia
Jo
-- 
Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir
belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de