Hi, hierarchical querys are a oracle specific feature, which is not supportet by DBIx::Class at the moment: http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries00 3.htm At the moment the only way to run such querys is, to use the "Arbitrary SQL through a custom ResultSource" workaround as described in the Cookbook. For this reason I created a patch, which enables DBIx::Class to run such query by passing additional arguments to a search statement. For example: my $search_result = $schema->resutlset('Person')->search({}, { 'start_with' => { 'firstname' => 'Foo', 'lastname' => 'Bar' }, 'connect_by' => { 'parentid' => 'prior personid' }, 'order_siblings_by => 'firstname ASC', }); The patch is attaced and I've already created a report in RT: http://rt.cpan.org/Public/Bug/Display.html?id=39121 Alex
oracle-hierarchical-queries.patch
Description: oracle-hierarchical-queries.patch
_______________________________________________ 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/[EMAIL PROTECTED]
