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 -
--
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.
