yelyah.nodrog Posted March 13, 2017 Share Posted March 13, 2017 Stupid question guys, I run a widget monthly to show exactly how many Service requests have been logged in the month. I have attempted to create a report to do this aswell. However it only gets as far as 1000 records then stops? i have to rerun it for the remaining days to get the rest of the records? Is this just me or is it a design issue? Thanks Hayley. Link to comment Share on other sites More sharing options...
James Ainsworth Posted March 13, 2017 Share Posted March 13, 2017 Hi Hayley, Thanks for your post. There is a setting in Administration that by default limits results to 1000. This is in place in order to help maintain performance. You are able to adjust this setting but I would recommend keeping it at a reasonable figure. In Administration navigate to System->Settings->Advanced Settings and search for the setting below and adjust accordingly. api.xmlmc.queryExec.maxResultsAllowed The maximum number of rows allowable in a query result. If the query exceeds the maximum size then an error will be returned to the caller. Regards, James Link to comment Share on other sites More sharing options...
yelyah.nodrog Posted March 16, 2017 Author Share Posted March 16, 2017 Thankyou very much for your help with this! Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now