[Dbix-class] Multiple-column subqueries

[Hernan Lopes]

Robert, maybe you want "as_query" ?

http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/ResultSet.pm#as_query

On Thu, May 10, 2018 at 2:00 PM, Robert Rothenberg <robrwo at gmail.com> wrote:

> It looks like the only way to use multiple-column subqueries in
> DBIx::Class is to define a virtual view, e.g. the SYNOPSIS in
> https://metacpan.org/pod/DBIx::Class::ResultSource
>
> If there is a better way to do this, I haven't found it online.
>
> Assuming that is the way... I am wondering if it's possible to create a
> new result source class at runtime (and if so, how).
>
> My thinking is that given a resultset, use that information to create a
> new result class that can be used as a result source (e.g. subquery).
>
>
>
>
>
> _______________________________________________
> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive: http://www.grokbase.com/group/
> dbix-class at lists.scsys.co.uk
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20180511/3738efe0/attachment.htm>