Quick way to search where Issue alternative assignee is being used

[Divya Yathagiri Venkata]

Hi,

I am looking for a quick way to search where Issue alternative assignee plugin is used in our JIRA instance. I tried to pull some data from the db but it didn't give me any results.

[Petter Gonçalves · Accepted solution]

Hello Divya,

Thank you for contacting Atlassian community!

I never used this plugin before, however, checking its description it seems that it uses a custom user picker field to allow you to select an alternative assignee to the issue. Is that correct?

The Custom field it creates is not searchable using JQL? You could write a query like this:

"custom field" is not empty

Please, let me know if this option is achievable. 

[Divya Yathagiri Venkata]

I am not sure what are the custom fields we created for usage of this plugin.

[Divya Yathagiri Venkata]

I tried to run this query from the db which didn't yield any results -

select * from jiraworkflows where descriptor like '%com.iamhuy.jira.plugin.issue-alternative-assignee%';

But I am not sure if that is how I should be checking it.

[Petter Gonçalves]

Thank you for your answer, Divya.

Unfortunately, I was not able to find any documentation describing how this field is described in the database.

However, checking the documentation related to this plugin, I find out that it adds a new type of custom field: "User Picker From Project Role"

That being said, you can navigate to the custom field page of your JIRA instance and search for fields of that type, so you will know its names and use the JQL as I mentioned before.

Can you let me know if this is possible?

[Divya Yathagiri Venkata]

That helps! Thanks Petterson!

[Petter Gonçalves]

You are welcome, Divya.

I'm glad to know I was able to help. Have a nice day!