# NAME DBIx::Class::Helper::ResultSet::WindowFunctions - Add support for window functions to DBIx::Class # VERSION version v0.1.2 # SYNOPSIS In a resultset: ```perl package MyApp::Schema::ResultSet::Wobbles; use base qw/DBIx::Class::ResultSet/; __PACKAGE__->load_components( qw/ Helper::ResultSet::WindowFunctions /); ``` Using the resultset: ```perl my $rs = $schema->resultset('Wobbles')->search_rs( undef. '+select' => { avg => 'fingers', -over => { partition_by => 'hats', order_by => 'age', }, }, '+as' => 'avg', ); ``` # DESCRIPTION This helper adds rudimentary support for window functions to [DBIx::Class](https://metacpan.org/pod/DBIx::Class) resultsets. # CAVEATS This module is experimental. Not all databases support window functions. # SEE ALSO [DBIx::Class](https://metacpan.org/pod/DBIx::Class) # SOURCE The development version is on github at [https://github.com/robrwo/DBIx-Class-Helper-ResultSet-WindowFunctions](https://github.com/robrwo/DBIx-Class-Helper-ResultSet-WindowFunctions) and may be cloned from [git://github.com/robrwo/DBIx-Class-Helper-ResultSet-WindowFunctions.git](git://github.com/robrwo/DBIx-Class-Helper-ResultSet-WindowFunctions.git) # BUGS Please report any bugs or feature requests on the bugtracker website [https://github.com/robrwo/DBIx-Class-Helper-ResultSet-WindowFunctions/issues](https://github.com/robrwo/DBIx-Class-Helper-ResultSet-WindowFunctions/issues) When submitting a bug or request, please include a test-file or a patch to an existing test-file that illustrates the bug or desired feature. # AUTHOR Robert Rothenberg # CONTRIBUTOR Peter Rabbitson # COPYRIGHT AND LICENSE This software is Copyright (c) 2018 by Robert Rothenberg. This is free software, licensed under: ``` The Artistic License 2.0 (GPL Compatible) ```