A simple way of solving this problem would be to add "touch => true" to
the DeviceMovement relationship:
belongs_to :device, :touch => true
This way, whenever a DeviceMovement is edited, the "updated_at" field in
the Device model is updated, and you could sort with this field.
If this doesn't fit your app, I would try with Ransack
(https://github.com/ernie/ransack). It's a gem that allows you to make
complex searches using simple params. It's quite easy to integrate into
Hobo: https://github.com/suyccom/hobo-metasearch
Regards,
Ignacio
El 24/03/13 09:05, Bernard Rault escribió:
In the context of a model ‘Device’ …. has_many :device_movements
I am trying to sort on a field of a record belonging to DeviceMovements
in devices_controller (I have unsuccessfully tried a number of things as
per the comments): at the moment I have denormalised the model and am
sorting on last_move..
/hobo_model_controller
auto_actions :all #, :except => :index
/
/
def index
hobo_
def index
hobo_index Device.tech_view.apply_scopes( :search => [params[:search],
:name],
# This is a Ruby gotcha - if you're going to put anything outside of
[a-zA-Z0-9_]
# in a symbol value, you need to quote it: eg
:'device_movements.last.created_at'
# :joins => :device_movements, # Check what this does; shows only
devices with movements; investigate further..
:order_by => parse_sort_param(:name, :product, :last_move,
'device_movements.last.created_at'))
#
Device.include(:device_movements).order_by(parse_sort_param("device_movements.last.created_at")))
end/
and in ../views/devices/index.dryml :
/<index-page>/
/<collection: replace>/
/<div>/
/<table-plus fields="this, product, last_move, age,
device_movements.last.created_at,
tech_status_changes.reverse.rotate.first" >/
/<last-move-heading-link:>Last Movement</last-move-heading-link:>/
/<last-move-view:><view format="%d %B %Y"/></last-move-view:>/
/<age-heading:>Days Waiting</age-heading:>/
/<device-movements-last-created-at-heading-link:>Dernier
Move</device-movements-last-created-at-heading-link:>/
/<device-movements-last-created-at-view:><view format="%d %B
%Y"/></device-movements-last-created-at-view:>/
/<tech-status-changes-reverse-rotate-first-heading:>Last
Status</tech-status-changes-reverse-rotate-first-heading:>/
/<controls:>/
/<transition-buttons/>/
/</controls:>/
/</table-plus>/
/</div>/
/</collection:>/
/</index-page>/
Can sorting on ‘/device_movements.last.created_at/’ be done or this is
viewed as a calculated field on which we cannot sort ?
--
You received this message because you are subscribed to the Google
Groups "Hobo Users" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/hobousers?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--
Ignacio Huerta Arteche
http://www.ihuerta.net
Teléfono: 0034 645 70 77 35
Email realizado con software libre
--
You received this message because you are subscribed to the Google Groups "Hobo
Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/hobousers?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
