Create a Project Picker Drop Down field for Service Desk

[Thomas Hardin]

I am trying to create a simple multi-picker drop down project picker field so that I can use it on the Service Desk portal. The purpose is that our team supports multiple changes across our entire instance, so requests need to identify the target project for the change.

We use scriptrunner, so my thought was to create a rest endpoint with a behavior that converts a text field accordingly. However, I cannot seem to find a good rest endpoint example that would pull a list of projects for me. I believe I have a couple of options also in that I could query the DB by pulling a list of project names or using an API to pull them, but I just can't get anything to work. 

If anyone has an example that would use either a DB query or API, please let me know. Or, if there are other alternatives, I am open to suggestions.

Thank you,

[Mechee]

There is a custom field type in Jira called Project Picker.

[Sam]

I've tried using this custom field, but whenever I try to add it to a request form, the field is forced to be hidden with a preset value.

Does anyone have a way of including this kind of field in Jira Service Desk?

[Mechee]

There's an open issue "Gathering Feedback". If you want to see the field, you should put your use case in the comments and vote for it: https://jira.atlassian.com/browse/JSDSERVER-86

[Eddy Fras]

Same problem for me here, I need a project picker in a service desk portal and for reasons I don't understand, Atlassian decided not to make the existing CF available in this context.

So, what's the best solution to get a project picker in a customer channel with Scriptrunner ?

• A DB picker scripted field ?

=> it's ok to get all projects but I can't find any documentation on how to use contextual data in SQL query (name of issue reporter to limit the list to the projects the current user has access to for example)

• A custom scripted field ?

=> this seems the most flexible solution but I can't find any doc/sample regarding the output type of the script according to the template you choose (a project picker template exists). The doc says :

 Use the following table as a guideline for which one to use:

|Your script returns…​|Template|Issue Panel|

|...|...|...|

|A project|Project Picker|main

But how can we return a single project to populate a project picker ?

• A custom field with an initializer of a behaviour ?
• Something else ?

[Bill Latham]

The paid plugin External Data for Jira Fields lets you use your Jira instance as a data source -- so I was able to create a project picker that basically does a rest call for projects -- I was then able to add the field to a Service Desk screen.  This is all using cloud -- Jira Cloud, External Data for Jira Fields looking into my Jira Cloud instance, and the Service Desk is in the same Jira Cloud instance.

That plugin is great anyway (and I don't work for them -- free plug).