Can't find all Tickets with search by "comment count"

[Matthias Klett]

Hi,

we have Jira SM Datacenter. I have installed the Toolkit for Jira Plugin, created a new custom field with the name "comment count" as a "number of comment" field and did a full re-index. I've added a column with "comment count" in the issue search and can see the number of comments for all Tickets. so calculating worked as expected. If I search for example "comment count" = 1 , I get only a small number of tickets as result (from today, but not every ticket from the system with 1). What is the problem? I did everything like in the confluence documentation.

BR
Matthias

[Hari Krishna]

Hi @Matthias Klett ,

The calculation itself is working correctly, which is why you can see the correct comment count in the issue navigator column.
However, the issue you’re facing is related to how Jira indexes calculated custom fields.

The “Comment count” field provided by Toolkit for Jira is a calculated field, and Jira does not always re-index historical values correctly for JQL searches. As a result:

Recently updated issues (new comments, recent activity) are indexed correctly and appear in search results

Older issues may display the correct value in the column, but their value is not searchable via JQL

This is a limitation of Jira’s indexing mechanism rather than a configuration issue on your side.

Things you can try:

Run a background re-index again and wait for it to fully complete

Update one of the missing issues (for example, add and remove a comment) to force a re-index of that issue

Check if the plugin provides a scheduled recalculation or re-index option for calculated fields

If consistent searching by comment count is critical, the plugin vendor may recommend an alternative approach or confirm this limitation, as Jira does not guarantee full JQL support for dynamically calculated fields across all historical issues.