Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Query with AND "Story Points" is EMPTY does not work Edited

Hi Community

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 support20210427 JIRA issue.png

1 answer

Hi @emmanuel_dolley 

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".

Best regards,

Bill

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.

Best regards

Emmanuel

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 ?

20210428 JIRA issue.png

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.

Thanks again.

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.  

Thanks!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS

Community Events

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

Events near you