Or was this meant to be used in direct conjunction with the :search named_scope?
On Mar 16, 1:35 pm, Tuishimi <[email protected]> wrote: > Hi Matt, not working for me. Is this a rails 3.0 thing with hobo, or > should an older version work as well? > > I get basically the same error I was getting before. I will paste it > here but I have to obfuscate the names a bit... > > OCIError: ORA-00904: "XXXXXXXXXX_TYPES"."NAME": invalid identifier: > select * from (SELECT * FROM "XXXXXXXXXX_VALUE_DETAILS" WHERE > ("XXXXXXXXXX_VALUE_DETAILS".XXXXXXXXXX_value_file_id = 10005) ORDER > BY XXXXXXXXXX_types.name ASC) where rownum <= 20 > > It is still trying to equate the order by field as part of the > XXXXXXXXXX_VALUE_DETAILS it would seem. > > I added the sort-column mapping in the dryml (eg, > 'XXXXXXXXXX_TYPE.NAME' => 'XXXXXXXXXX_TYPES.NAME', then I added the > parse_sort_param() including the 'XXXXXXXXXX_TYPES.NAME'. > > I must be missing something? > > On Mar 16, 12:25 pm, Matt Jones <[email protected]> wrote: > > > > > On Mar 16, 2011, at 3:02 PM, Tuishimi wrote: > > > On the sorting front, you can already pass a table-qualified reference to > > parse_sort_param: > > > parse_sort_param('users.first_name', 'users.last_name', :registered_on, > > :graduated_on, :inactive) > > > (for the standard order_by Hobo scope). The only gotcha is that the field > > name here is NOT the one that table-plus wants (users.first_name vs. > > user.first_name), so you'll need to help it out: > > > <table-plus fields="user.last_name, user.first_name, registered_on, > > graduated_on, inactive" sort-columns="&{'user.last_name' => > > 'users.last_name', 'user.first_name' => 'users.first_name'}"> > > > Yes, it's messy - but it works! Ideally we'd get this working so table-plus > > knows how to do this itself. > > > Hope this helps! > > > --Matt Jones- Hide quoted text - > > > - Show quoted text -- Hide quoted text - > > - Show quoted text - -- You received this message because you are subscribed to the Google Groups "Hobo Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/hobousers?hl=en.
