要約

Searching for the team field value below shows the same issue result even though the team field value was different. 

例:

cf[12611] = 704 AND KEY = TEST-8057

cf[12611] = 707 AND KEY = TEST-8057

Both return the same results. 

cf[12611] = Team field

予想される結果

Searching the team field shouldn't be showing the same issue because of both different team IDs.

環境

Jira Software 8.20.10

診断

You have completed Full Indexing and still encounter the issue.

The affected issue must be a subtask issue type. If yes, please run the following SQL query:

select 
(select (select pkey from project where id = project) || '-' || issuenum from jiraissue where id = entity_id) as issuekey, 
json_value 
from entity_property 
where entity_name = 'IssueProperty' and property_key = 'jpo-issue-properties' and json_value like '%team_id%' 
and entity_id in (select id from jiraissue where issuenum in (ISSUE_NUM) and project in (select id from project where pkey = 'PROJ_KEY'));

Replace PROJ_KEY to the affected project key => TEST

Replace ISSUE_NUM to the number of the issue key => 8057

If returns results, please proceed with the solution below.

原因

The subtask issue team value is stored in the entity_property table that causes the searching issue.

ソリューション

I recommend following the steps below to fix the data in a Test/Dev environment to ensure is working:

1. Back up Jira data before proceeding to the next step.
2. Jira を停止します。

3. Run the following SQL query to delete the invalid data: 

   delete from entity_property where entity_name = 'IssueProperty' and property_key = 'jpo-issue-properties' and json_value like '%team_id%' and entity_id in (select id from jiraissue where issuenum in (ISSUE_NUM) and project in (select id from project where pkey = 'PROJ_KEY')); 

4. Jira を再起動します。
5. Performed a full reindexing.