Unread Mail widget gives different results through Dashboard API (lists trash too)

[AlvaroBrey]

Steps to reproduce

1. Have some unread mails in the Trash, and one in the Inbox
2. See the Unread Mail widget in the web dashboard, which shows only the unread mail in the Inbox
3. Get the unread mail through the API:
   curl -u user:pass "http:/nextcloud.address/ocs/v2.php/apps/dashboard/api/v1/widget-items?widgets[]=mail-unread" -H "Accept: application/json"

Expected behavior

Dashboard API should return the same unread mails as seen in the web dashboard, i.e. only the ones in Inbox.

Actual behavior

API response contains the unread mail in Inbox, followed by the unread mails in Trash.

Mail app version

No response

Mailserver or service

No response

Operating system

No response

PHP engine version

No response

Web server

No response

Database

No response

Additional info

Versions are whatever we have in our company server

Originally reported in nextcloud/android#10873

[Emporea]

This problem still occurs.

[ChristophWurst]

@st3iny mind having a look?

[Emporea]

Especially since the 27.1 update, it also appears in the web interface, not just in an Android widget.

[ChristophWurst]

Because of #8831

[Emporea]

Has anyone used the email dashboard widget on the web interface? I wonder why there has been no talk about this.

I don't mean to suggest there hasn't been any, but I raised this problem almost a year ago.

[Emporea]

Any Updates? Or any way i could help with logs?
This doesnt just affect the Dashboard, but also the nextcloud android app mail widget.

[ChristophWurst]

I don't think logs help here.

Best would be to attach a debugger and step through the code to find out where the messages come from. E.g. by analyzing the db query.