Unused custom field 'case_attachments_display' causing slowness in cases module listing #5369

New issue

Open

opened 2026-02-20 17:00:17 -05:00 by deekerman · 0 comments

deekerman commented

2026-02-20 17:00:17 -05:00

Owner

Originally created by @rahulshinde19 on GitHub (Feb 7, 2026).

Issue

While testing I found that cases module listing is very slow, after investigation we found that there are lot of notes in my application and all notes are being loaded on listing page unnecessary. Those are not shown on UI anywhere.

The custom field "case_attachments_display" is listed in vardefs which fetching notes but this field is not used anywhere.
function display_case_attachments($case)
This function is being called on listing page of cases as well and fetching ALL notes, causing delay in Cases listing page if application has many notes.

If anyone need to see the list of notes for that particular then it can be shown as subpanel in details view, it should not fetch as field.

Possible Fix

remove the custom field 'case_attachments_display' and its traces

Steps to Reproduce the Issue

1. Add many notes in your application 
2. Check the performance of cases list page.
3. It will take time to load Cases listing page if many notes exists in your application, doesn't matter if it is linked to any case or not.

Context

We have lot of notes in our local application, Our testing team reported an issue: cases module listing is slow,
after investigation we found that all notes are being loaded on listing page unnecessary and those are not shown on UI anywhere.

Version

7.15.0

What browser are you currently using?

Chrome

Browser Version

Chrome Version 144.0.7559.110 (Official Build) (64-bit)

Environment Information

MySQL, PHP 8.2

Operating System and Version

Ubuntu 23.10

Originally created by @rahulshinde19 on GitHub (Feb 7, 2026). ### Issue While testing I found that cases module listing is very slow, after investigation we found that there are lot of notes in my application and all notes are being loaded on listing page unnecessary. Those are not shown on UI anywhere. The custom field "case_attachments_display" is listed in vardefs which fetching notes but this field is not used anywhere. function display_case_attachments($case) This function is being called on listing page of cases as well and fetching ALL notes, causing delay in Cases listing page if application has many notes. If anyone need to see the list of notes for that particular then it can be shown as subpanel in details view, it should not fetch as field. ### Possible Fix remove the custom field 'case_attachments_display' and its traces ### Steps to Reproduce the Issue ```bash 1. Add many notes in your application 2. Check the performance of cases list page. 3. It will take time to load Cases listing page if many notes exists in your application, doesn't matter if it is linked to any case or not. ``` ### Context We have lot of notes in our local application, Our testing team reported an issue: cases module listing is slow, after investigation we found that all notes are being loaded on listing page unnecessary and those are not shown on UI anywhere. ### Version 7.15.0 ### What browser are you currently using? Chrome ### Browser Version Chrome Version 144.0.7559.110 (Official Build) (64-bit) ### Environment Information MySQL, PHP 8.2 ### Operating System and Version Ubuntu 23.10