Unread in Trash

[zombiebsas]

When I execute this from the console it returns the same number of conversations:

User.find(1).mailbox.trash(:is_read => true) 

vs:

User.find(1).mailbox.trash(:is_read => false)

Or even:

User.find(1).mailbox.trash(:unread => true) 

vs:

User.find(1).mailbox.trash(:unread => false)

When I use :unread => true I get this SQL from the console:

SELECT DISTINCT conversations.* FROM "conversations" 
INNER JOIN "notifications" ON "notifications"."conversation_id" = "conversations"."id" AND "notifications"."type" IN ('Message') 
INNER JOIN "receipts" ON "receipts"."notification_id" = "notifications"."id" 
WHERE "receipts"."trashed" = 't' 
AND "receipts"."deleted" = 'f' 
AND "notifications"."type" = 'Message' 
AND "receipts"."receiver_id" = 1 
AND "receipts"."receiver_type" = 'User' 
AND "receipts"."is_read" = 'f' 
ORDER BY conversations.updated_at DESC

In the last condition it's clear that the SQL is filtering by is_read = 'f'
Am I doing something wrong or this is a bug? I would like to be able to count how many unread messages I trashed.

Thanks.
-A.

[w3irdrobot]

You are getting everything from conversations here. So my guess is they you have read and unread receipts trashed from the same conversations. So it is returning the same conversations. This isn't returning the individual receipts. Try something like below:

User.find(1).receipts.trash.is_unread