How can I view the Jira "project role" field in a filter?

[Pete P]

I need to create some filters based on Jira project role. I don't see Project role in the picker, there is something called "Team Role" but the values returned all say "None".  What is going on here?

[Renjith Pillai · Accepted solution]

https://confluence.atlassian.com/display/JIRA/Retrieving+the+JIRA+Administrator

[Norbert]

Thanks for the quick help

[RianA]

You could restore the local adminsitrator in JIRA by following this documentation. Please do backup your JIRA database for safety purpose. In addition to that, you might need to also run the following query, but please make sure there's no other directory that has 0 as directory_position as its value.

updatecwd_directory setdirectory_position = 0 whereid = 1;

Hope it helps.