why did this happen can you please let me know and how I can fix this?
Pagination Showing Incorrect Ticket Count in Search Results
- Looks like you are using a modified version as we don’t have that specific error message.
- Looks like you are not all the way up to date. I would suggest upgrading to v1.18.2 and retesting.
Cheers.
- Edited
We updated to 1.18.2 last week and started to experience this issue for the first time.
It seems to be displaying the total of all tickets across all departments.
What is the queue's configuration? I cannot replicate this nor have I received any other reports than you two. Do you have any modifications? Do you have any referred Tickets, assigned tickets, children tickets, etc. related to Tickets in this queue?
Cheers.
We have only ever used the default settings for Queues:
Also, no modifications of any kind have been made to our installation. It's basically a vanilla installation aside from the plugins we have installed.
- Edited
Okay, during off hours login to the help desk, go to the queue, go to the include/class.orm.php file on line 3481, make a new line under it, add var_dump($sql);, save the file, go to the queue, reload the page, and find the query for the queue. Copy the whole query and run it in MySQL/MariaDB and compare that with what you see in the UI. Make sure you remove the change as fast as possible so no one has issues. Let me know the outcome.
Cheers.
21 days later
Here's the change that we made:
And this was the resulting output:
Did you ever try this?
Cheers.
Thank you for pointing that out. Yes, this did resolve the issue.
Hello,
We encountered the same issue after upgrading to v1.18.2. Adding $agent as an argument helped resolve the problem. It seems that we are not using any custom functionality. Will this patch be included in the next release?
mirkt Of course.