Scroll to navigation

DBIx::Class::Helper::ResultSet::RemoveColumns(3pm) User Contributed Perl Documentation DBIx::Class::Helper::ResultSet::RemoveColumns(3pm)


DBIx::Class::Helper::ResultSet::RemoveColumns - 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 <>


This software is copyright (c) 2020 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.

2020-03-29 perl v5.30.0