Limitation of Jira DC Index
Including Jira version 8.22.2 and other versions thereafter, jira will now index only the topN (can be set to 500, 1000, or 10_000) of the following issue-related entities: comments, change history, and work log. The newest N of entities will be reindexed. Jira is only re-indexing the first 50 worklogs by default, and if an issue has a lot of worklogs, they are not being indexed. This may result in the absence of issues in the relevant JQL. This value can be increased to 1000 to ensure that a much higher number of worklogs are indexed.
Jira admins can change default topN values for worklog entities by setting a system property to the desired limit. System property name for issue worklog entry is jira.safeguards.indexing.issue.worklogs.
It’s also possible to disable the feature by setting the corresponding system property to -1.
Updating the System Properties to change this value
Navigate to JIRA_INSTALL/bin
Edit the setenv file (.bat for windows, .sh for linux)
Change JVM_SUPPORT_RECOMMENDED_ARGS="" to JVM_SUPPORT_RECOMMENDED_ARGS="-Djira.safeguards.indexing.issue.worklogs=5000". Please note that the 5000 is an example value.
Restart Jira