I have an issue with a "simple" query :
project = MYPROJECT AND issuetype = Story AND "Story Points" is EMPTY order by created DESC
returns stories with story points estimations.
I have the same behavior with Story Points[Number].
With JIRA Cloud for Sheets plugin too.
Where is my mistake ?
Thanks in advance for your support
Are you using a Team-Managed project (formerly called next-gen) or a Company-Managed project (formerly called classic)? You may see this if you expand the left panel and look at the bottom.
For queries, Team-Managed projects use Story Point Estimate, while Company-Managed use Story Points. Both appear on the views as "Story Points".
Hi @Bill Sheboy ,
Thank you for your support.
The project is a company-managed project.
I have tested is EMPTY / in (EMPTY) with "Story Points" / "Story point estimate" / "Story Points[Number]". This query part is ignored.
I have tested "Story Points[Number]" = "5" and it works as expected
By the way, using another field with is EMPTY is working too.
Thanks for that information, Emmanuel. I tried that query and it works correctly for me.
Next, please check with your site admin to learn if there is a custom field that was created with the same name as "story points". You can also check this yourself by typing in a query, starting to type "story points" and see if there are more resulting fields than expected. One fields value could be getting queried while the other is being displayed.
If that is not it, I wonder if what you are seeing is related to the fix Atlassian is rolling out for IS EMPTY not working for text fields which have been cleared of a previous value.
I think your next step may be to ask your site admin to submit a support ticket to Atlassian here: https://support.atlassian.com/contact/#/ As you are on a paid, standard version they should be able to create the ticket.
Once you hear back from support, please post what you learn so the whole community can benefit. Thanks!
Thanks a lot for your help and the link to the issue.
Regarding the custom field, there is one similar, but not exactly the same (cf picture). How can I check that this custom field is the the root cause of my issue ? Is there a way without removing this custom field ?
Regarding to the " IS EMPTY not working for text fields which have been cleared of a previous value" issue, it seems the opposite of my behavior : if I have well understood in this issue, the field is no more seen as empty, even if it is. In my issue the field is seen as empty, but is not.
I will contact my site admin, as you advice me, in order to check the 1st point, and will update the thread if there is some improvement.
Looks like you are okay regarding any fields; the "Story point estimate" field is the one used by Team-managed (next-gen) projects to handle story points. So no problem there.
Yes, I understood the symptom you observed is different from that defect. What I wondered was if the fix being rolled out was causing side-effects. I agree it is time to ask support about this one.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events