Except in rails not working

Question

I have this code:

  @note = @patient.notes.find(params[:id])
  @notes = @patient.notes.where(jahr: @note.jahr, quartal: @note.quartal).except(@note)

Somehow the .except(@note) is not working, i get no error, but @note is still contained in @notes What do i wrong? Thanks!

http://stackoverflow.com/questions/2672744/rails-activerecord-find-all-users-except-current-user — astropanic, Mar 22 '14 at 08:15

score 2 · Accepted Answer · answered Mar 22 '14 at 08:19

2

except is used to skip parts of your query, as in .except(:where) to skip the where clause. You might want to use something like .where('notes.id != ?', @note.id) instead. Or in Rails 4, where.not.

answered Mar 22 '14 at 08:19

jimworm

2,731
18
26

Except in rails not working

1 Answers1