As part of my JIRA service desk install I have a custom field that holds a serial number.
What I need to get to is a way of being able to show a list of other issues with the same value in the custom field.
Obviously this can be done easily with a quick search, however I was wondering if a plugin similar to suggestimate exists which would allow for a list of issues to display in the issue based on having the same value in a specific custom field, or perhaps something which can use a post-function to check if that value in a custom field already exists in an open issue.
I use this SQL to get dublicates:
Select project.pkey + '-' + CAST(jiraissue.issuenum as varchar(20)) , customfieldvalue.* from (Select customfield.ID , customfieldvalue.STRINGVALUE from customfield join customfieldvalue on customfield.ID = customfieldvalue.CUSTOMFIELD where customfield.cfname = 'Разработчик' --type custom field name here group by customfield.ID , customfieldvalue.STRINGVALUE --change value type here having COUNT(customfieldvalue.STRINGVALUE) > 1 --change value type here ) as dublicates join customfieldvalue join jiraissue join project on jiraissue.PROJECT = project.ID on customfieldvalue.ISSUE = jiraissue.ID on dublicates.ID = customfieldvalue.CUSTOMFIELD and dublicates.STRINGVALUE = customfieldvalue.STRINGVALUE order by customfieldvalue.STRINGVALUE
Hello and thanks for response,
If I have an issue in JIRA which relates to a specific serial number (Where the serial number is a value in a custom field), then what I want to do is then display in JIRA a list of all issues related to that serial number - so any issue which has a duplicate value in that custom field. The idea being it gives a history of interactions with that serial number.
I found an addon called suggestimate which provides similar functionality but it appears that this is only based on the summary field.
Does that make sense?
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG