E-mails Waiting/New E-mails Count Widget

[dwalby]

Hi all,

Is it possible to create a widget which shows the current number of new e-mails awaiting to be raised as requests? i.e. a count of the number of e-mails in the inbox?

Thanks in advance

[Victor]

On 11/28/2018 at 8:20 AM, dwalby said:

a count of the number of e-mails in the inbox?

What exactly will it count? all? unread?

[dwalby]

@Victor sorry, all e-mails ideally, from the Inbox only.

[Victor]

@dwalby - ok. First, we need to find out the folder ID for the "inbox". When you navigate to Inbox in the email view, have a look at the URL in the address bar. In there it should be something like "folder= <number>". We need that number.

Once we have the number then a widget to count emails in Inbox should be quite simple. Have the widget configured to use a custom SQL and the query would be:

SELECT COUNT(*) AS "Your Desired Column Name" FROM h_msg_messages WHERE h_folder_id = <number>

 

[dwalby]

@Victor - Awesome this worked  Thanks again!