3

I am currently using attr_encrypted gem to encrypt content so that only users that have a certain key can see portions of documents available to a broader group. Everything works fine until I try to sort the list on one of the encrypted fields. I've read the documentation several times and experimented several way to no avail.

In the CommunityMember model:

attr_encrypted :last_name, :key => :encryption_key

In the controller I have tried 

@list = CommunityMember.order("last_name")
AND
@list = CommunityMember.order("encrypted_#{last_name}")
AND
@list = CommunityMember.order("encrypted_#{'last_name'}")

None produced the desired result. Thanks for your help.

Jay

Jay
  • 6,206
  • 11
  • 48
  • 82

1 Answers1

3

You can use the sort_by method

@list = CommunityMember.all.sort_by(&:last_name)
Jan Klimo
  • 4,643
  • 2
  • 36
  • 42
Eyeslandic
  • 14,553
  • 13
  • 41
  • 54