Problem with my request

[Equipe Support Squash]

Hello, 

I encounter a problem when I run the request : Sprint in openSprint()

I have error messages :  

The option provided by the ‘openSprints’ function for the ‘Sprint’ field does not exist. Several custom fields have the name ‘Sprint’. Try using one of the following terms: cf[10020], ‘Sprint[Dropdown]’.

And when I search in the custom field, I only have one Sprint field locked

Do you have any solution ? 

Regards, 

Claire

[Manon Soubies-Camy · Accepted solution]

Hi @Equipe Support Squash,

The screenshot shows that you're typing Sprint in Sprintactif() instead of the correct JQL function:

sprint in openSprints() 

Even if your profile language is set to French, you need to type JQL functions as written in the documentation.

Hope this helps!

- Manon

[Equipe Support Squash]

Yes sorry i didn't send the good pictures because I test several ways of writing Sprint

[Manon Soubies-Camy]

Thanks for the additional screenshot! Can you confirm that you can see several different custom fields named "Sprint" in the administration? Looks like this is the issue. Since you also have a dropdown custom field named Sprint, Jira doesn't know which one to use in the query.

Can you try this JQL query instead:

cf[10020] in OpenSprints()

10020 is the id of the original Sprint custom field, the one created by Jira.

[Equipe Support Squash]

Hello, 

Unfortunately, I only see the one custom fields Sprint (on the second screenshot) 

I already test with this JQL but I cannot understand why overnight the first request stop working
No new custom field with Sprint in the name was created

[Manon Soubies-Camy]

Do you have any team-managed projects?

I created a new dropdown field that I named "Sprint2" in a team-managed project, and it does not show up in the global Custom fields menu. I do see it in the global audit log though:

Could that be the issue?

[Equipe Support Squash]

When I searched i could find this one :

It could be the issue ? 

[Manon Soubies-Camy]

Looks like it! You can try the following JQL query to understand which project this comes from:

"Sprint[Dropdown]" is not empty

Or just ask your colleagues if they remember who created it on that day :)

[Equipe Support Squash]

Unfortunately, no one remember creating it..

And don't know where I can run this request to find the custom field created

[Manon Soubies-Camy]

You can run it in the issue search, where you ran the "Sprint in openSprints()" one. It will only work if users filled out this field, though - if no one uses the new Sprint field, it won't return anything.

[Equipe Support Squash]

Hello, 

Do you have any ideas to find the ID of the Sprint[dropdown], rename it, or delete it? 
or could also get an API to do it ? 

Thank you very much for your help ! 

[Manon Soubies-Camy]

Hi @Equipe Support Squash,

Sure, you can rename the custom field from the team-managed project's admin menu:

Hope this helps!

[Equipe Support Squash]

Hello Manon !! 

Thank you ! It's help me a lot !
It's now working ! 

Have a great day ! 

[Manon Soubies-Camy]

Great, thanks for letting me know! :)

[Jim Knepley - ReleaseTEAM]

This question has come up before:

https://community.atlassian.com/t5/Jira-questions/Error-when-trying-to-use-openSprint-query/qaq-p/1171282

https://community.atlassian.com/t5/Jira-questions/JQL-openSprints-stopped-working/qaq-p/1208181

But your example query using the capitalized "Sprint" field looks correct. I wonder if there's some issue because you have a custom field named Sprint.

[Equipe Support Squash]

Hello, 

Yes, these too :

https://community.atlassian.com/t5/Jira-questions/OpenSprints-function-does-not-work-in-JQL-Jira-anymore/qaq-p/2606463

https://community.atlassian.com/t5/Jira-questions/Filters-Not-Working/qaq-p/2614650

The query stopped working overnight.

I'm following the same steps but cannot go further due to locked field