Man pages sections > man3 > DBIx::Class::Helper::ResultSet::RemoveColumns

DBIx::Class::Helper::ResultSet::RemoveColumns - Remove columns from a ResultSet

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

NAME

DBIx::Class::Helper::ResultSet::RemoveColumns - Remove columns from a ResultSet

SYNOPSIS

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

DESCRIPTION

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.

AUTHOR

Arthur Axel "fREW" Schmidt <frioux+cpan@gmail.com> This software is copyright (c) 2017 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.
2017-07-03 perl v5.24.1