Email Digest not working when Email Notifications disabled
I thought the existing options for email digest (staff > Other Options > Email Digest > Enable Email Digest) and mail notification (Staff > Other Options > Email Settings > Enable Email Notifications) are intended for this case:
I want mail notification but no mail digest => mail digest [-] / mail notification [x]
I want no mail notification but mail digest => mail digest [x] / mail notification [-]
I want both mail notification and mail digest => mail digest [x] / mail notification [x]
I want no mail notification and no mail digest => mail digest [-] / mail notification [-]
New tickets, no replies / Tickets awaiting staff response / Tickets awaiting visitor response => reported even if tickets not assigned to the specific supporter
No no, this updated query works perfectly (in my query there is a AND before `assignedto`=\'\' and not an OR) ... at least for us
When the supporter is assigned to an department !empty($dept)
=> the query shows only tickets which are assigned to the supporter (FIND_IN_SET(\'' . $USERS->id . '\', `assignedto`) > 0)
=> OR are assigned to his department but are not assigned to a specific supporter (when manual ticket assignment is disabled) (`department` IN(' . mswSQL(implode(',', $dept)) . ') AND `assignedto`=\'\')
=> I used `assignedto`=\'\' instead of FIND_IN_SET() because I don't want ticket listed here which are waiting for assignment.
Example: We are three supporters in the department "Software". Without the updated query I (for example) get a list with all new tickets with no replies - even if the tickets are not assigned to me => But I only wants to know which of mine new tickets with no replies waiting for action.
The "live screen option" sounds very nice and if it is structered like the email digest it would be a great feature