0

I am sure this is a simple syntax issue and I am taking a chance by asking the question but I just can't figure it out on my own. I have a functioning Filterrific :sorted_by selector, works great, sorts my Ticket records according to field values text and date types.

My Tickets table joins to a Comments table in a one-to-many relationship, and I am trying to sort a set of Ticket records by the newest update date from its associated Comment records.

Initially my solution was to add this to my scope:

when /*comment_date/
order("tickets.comments.updated_at #{direction}").includes(:comments).references(:comments)

The behavior is perplexing, my data is not being sorted across pagination, but perhaps coincidentally the records on a selected page are in order. I would love to post the backend SQL but work constraints do not allow it, so I hope I am not scolded or chastised for not providing enough evidence of my research.

Trying to find examples of Filterrific solutions is tough, after awhile I keep seeing the same posts on different websites. I have read every open and closed issue on GitHub, and the 79 or so tagged questions here on SO. It's so frustrating because I am sure there is a simple, logical solution but I can't see it!

As always, thank you for your time. I consider your attention a privilege, not a right, and I value any guidance.

Jennifer Mansker-Bickel
  • 49
  • 1
  • 7
  • 1
    Could you add a bit more context around your ActiveRecord code? Also, instead of `order("tickets.comments.updated_at #{direction}")` you should use `order(tickets: {comments: {updated_at: :asc}})`. – thesecretmaster Aug 01 '19 at 16:27
  • 2
    Also, as a complete solution, you should try `join`-ing the comments table rather than `include`ing it. Using `includes` tells rails to fetch the comments in a separate query IIRC, which would explain your issue. – thesecretmaster Aug 01 '19 at 16:28
  • Now THAT is the kind of advice I treasure! I will apply your suggestions, and post an update, with an example of my ActiveRecord code, if needed. – Jennifer Mansker-Bickel Aug 01 '19 at 18:13
  • [This question](https://stackoverflow.com/q/1208636/4948732) about `includes` vs `joins` may be helpful as well. – thesecretmaster Aug 01 '19 at 18:21

1 Answers1

0

Use joins instead of includes that way, the table is in your query.

...joins(:comments).references(:comments)

Same as what @thesecretmaster mentioned. Just making a post so you can close this

Dan
  • 54
  • 1
  • 4