DBIx::Class::Helper::ResultSet::RemoveColumns(3) Remove columns from a ResultSet


package MySchema::ResultSet::Bar;
use strict;
use warnings;
use parent 'DBIx::Class::ResultSet';
# in code using resultset:
my $rs = $schema->resultset('Bar')->search(undef, {
remove_columns => ['giant_text_col', 'password'],


This component allows convenient removal of columns from a select. Normally to do this you would do this by listing all of the columns except the ones you want to remove. This does that part for you. See ``NOTE'' in DBIx::Class::Helper::ResultSet for a nice way to apply it to your entire schema.

It doesn't get a lot more complicated than the synopsis. If you are interested in having more control, check out DBIx::Class::Helper::ResultSet::AutoRemoveColumns.

  • Load the component
  • Put an "ArrayRef" of columns to remove in the "remove_columns" search attribute.
  • Profit.


Arthur Axel ``fREW'' Schmidt <[email protected]>


This software is copyright (c) 2015 by Arthur Axel ``fREW'' Schmidt.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.