I actually had to use the relationship name, i.e. account_id.sunset_date. This solved it for three of the four items. The "percent_complete" isn't even showing that it is being prefetched. I did find that it is a view so maybe I need to take it out of the prefetch section.
Regards Kenneth McLane 700 Locust St Systems Compliance Services Dubuque, 52001-6838 I1OB USA GTS Services Delivery Phone: +1-563-845-4674 Tie-Line: 946-4674 Mobile: +1-563-940-7147 e-mail: [email protected] "Ideas come from everything" -- Alfred Hitchcock From: Ronald J Kimball <[email protected]> To: "DBIx::Class user and developer list" <[email protected]> Date: 05/04/2012 11:29 AM Subject: Re: [Dbix-class] Adding a case statement to a ResultSet On Fri, May 4, 2012 at 12:12 PM, Kenneth S Mclane <[email protected]> wrote: adds the case statement to the sql, but I get an error that "sunset_date" is ambiguous. If I specify it as "account.sunset_date" I get "account.sunset_date is invalid in the context it is being used in." Try me.sunset_date. See the documentation for join in DBIx::Class::ResultSet. Ronald _______________________________________________ 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]
<<image/gif>>
_______________________________________________ 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]
