### unique transits for org my $orguniq_rs = $org_rs->search( {}, { group_by => [ qw/name/ ] } ); ### unique transits for org type cargo my $one_rs = $orguniq_rs->search( { 'type' => { '=' => 'one' } } ); ### unique transits for org type tanker my $two_rs = $orguniq_rs->search( { 'type' => { '=' => 'two' } } ); ### unique transits for org type other my $other_rs = $orguniq_rs->search( { 'type' => { '!=' => [ 'one', 'two' ] } } );