Hello,
We previously had a widget setup that would show each users record number of calls resolved within a working week ever.
It simply showed their name and their record number of calls resolved.
However, we have not used this for a while and when I went to look at it today it flagged up an error stating "The maximum number of rows allowed (100) has been exceeded, query aborted".
The query is as follows:
SELECT
h_resolvedby_user_id,
COUNT(h_pk_reference) as resolved_count,
CONCAT(YEAR(h_datelogged), '/', WEEK(h_datelogged)) as year_week
FROM
h_itsm_requests
WHERE
h_resolvedby_user_id IS NOT NULL
GROUP BY
h_resolvedby_user_id, year_week
ORDER BY
resolved_count DESC
Can anyone help?
Is there a better way to do this now?