James Bartle Posted August 8, 2018 Share Posted August 8, 2018 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? Link to comment Share on other sites More sharing options...
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now