Use logged-in user as variable

akunnari

Hello,

 

I'm trying to configure a dropdown-list, which has specific values depending on the user, who opens it. For this I am using the custom field "Database Picker" which uses a SQL query to get the input from a DB, now to my actual question:

 

I need to write some Script via ScriptRunner for this field, with which I am unfamiliar with. How do I use the "logged-in-User" as a variable? Since I need to use it in the SQL query to select the right content for the dropdown-list...

 

Thanks!

Will C

if you use 

import com.atlassian.jira.component.ComponentAccessor
def user = ComponentAccessor.getJiraAuthenticationContext().getLoggedInUser()

 This will pass you the logged in user as a variable, use .name on the end to pass this variable as a string