我正在使用Noticed gem作为通知，并尝试查询与帖子相关的通知。通知将帖子作为对象存储在params中。

#<Notification id: 10, params: {:post=>#<Post id: 3}>

我可以瞄准

notification.params[:post][:id] 
=> 3

我试图完成的事情是这样的：

Notifications.where(params[:post][:id] => 3)

有没有办法做到这一点，或者我的方法应该不同？

编辑日期：

以下是数据库中的通知示例：

#<Notification id: 10, recipient_type: "User", recipient_id: 8, type: "MessageNotification", params: {:user=>#<User id: 3, email: "test2@test2.com", created_at: "2021-01-06 23:34:46", updated_at: "2021-04-15 17:47:54", admin: true>, :conversation=>#<Mailboxer::Conversation id: 6, subject: "Hello", created_at: "2021-05-14 00:14:41", updated_at: "2021-05-14 00:26:06">}, read_at: nil, created_at: "2021-05-14 00:26:06", updated_at: "2021-05-14 17:11:50">

squema.rb

t.jsonb "params"

@Joel_Blum建议的查询和slq调用：

>> current_user.notifications.where('params @> ?', {conversation: {id: 6}}.to_json).to_sql
=> "SELECT \"notifications\".* FROM \"notifications\" WHERE \"notifications\".\"recipient_id\" = 8 AND \"notifications\".\"recipient_type\" = 'User' AND (params @> '{\"conversation\":{\"id\":6}}')"

Returns => #<ActiveRecord::AssociationRelation []>