I have a list of close to 200 empty projects (no issues inside). I need to retrieve information of all the project owners & users in each of these individual project.
What would be the best possible way get all these information.
Thank you
Hi @Aisha M
Welcome back to Jira!!
You can get the list of Project lead from API by providing the Project
For getting the list of users who have access to the project, here's a post in Community that I have posted!!
Thanks,
Pramodh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello @Aisha M I am perfectly fine, I hope you are too. Welcome back, I see you are using cloud this time. :)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Antoine Berry I understand there is a page about it, but its just too much overwhelming information for someone trying to configure this for the first time . . . I have been searching for some real time videos of someone configuring it but couldn't find any . . ;(
Have so many questions like, my users are using outlook . . what info must be provided for setting up the incoming mail & mail handler . . Should we have a dedicated mail server for the incoming mail server for IMAP or POPS . . so confused :D
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Antoine Berry I thought so too . . But that was on my personal setup . . Dunno what's gonna happen while setting up in my org :D
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Antoine Berry , Can you pleaseee help me with the below question . .
So, I have a listener. And there are a huge bunch of projects that the listener works on . . . How to do I ensure the listener picks up the list of projects from a DB instead of manually adding the projects everytime ?
What additional script should I add to the existing listener to make sure it picks the projects from the DB table ?
Any idea ? :(:(
Incase yer interested - https://community.atlassian.com/t5/Jira-questions/Need-help-with-Script-listener/qaq-p/1947386
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Antoine Berry I'm yet to try the code, waiting on my access to the db . . Praying to the JIRA Gods it work ;( Really really really hope it works
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It will surely work. And if it does not, there is a way to fix it. :)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Antoine Berry Okay, so I have the below script in my service desk to capture the project to db.
So, instead of the custom field "Work" if I need to capture the Board ID (along with the project key). . Can I used a simple text field to do so ?
import com.onresolve.scriptrunner.db.DatabaseUtil
import com.atlassian.jira.component.ComponentAccessor
import imagineersCF.getDropDownValue
def cfm = ComponentAccessor.customFieldManager
def AtlValCF = cfm.getCustomFieldObjectsByName("Atl Project Picker Key")[0]
def strTeamOperation = getDropDownValue.getDD(issue,"Team Operation")
def strWork = getDropDownValue.getDD(issue,"Work")
def AtlVal = issue.getCustomFieldValue(AtlValCF)?.toString().toUpperCase()
def projectKey = issue.getProjectObject().key.toUpperCase()
def loggedInUser = ComponentAccessor.jiraAuthenticationContext.loggedInUser.name.toUpperCase()
if(strTeamOperation == "Add"){
def query = """ EXECUTE [dbo].[sp_Update_Default_Value_No_Output_MYD] 'Work','${AtlVal}',null, '${loggedInUser}','${strWork}',1 """
DatabaseUtil.withSql('my_database') { sql ->
sql.execute(query.toString())
log.error(query.toString())
}
}
}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Aisha M ,
I am not too familiar with SQL queries in groovy. I would need to look further in details.
I guess you got this script from your other post ? So it should be trustworthy.
What is the issue with it ? Also do you have a getDropDownValue function in your script ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Antoine Berry That is alright :):) I was able to fix it . . But thank you for willing to help . . :):)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.