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

Use Custom Field Name vs. Custom Field ID

I have a Custom Field Name I want to use:

"Story Points[Number]" is EMPTY ORDER BY created DESC

But is does not return the desired results.

 

Using Field ID does work, but is not desired:

 cf[10012] is EMPTY ORDER BY created DESC

 

Why am I unable to use the field name?

2 answers

0 votes
Alexis Robert Community Leader Apr 23, 2021

Hi @Matthew Risch , 

 

I'm not sure why it doesn't work for you, I was able to test and confirm that I'm able to use the field name when doing a JQL search :

"Change completion date[Time stamp]" is not empty

 

You can see the query below : 

 

Screenshot 2021-04-23 at 14.51.13.png

Let me know if this helps, 

 

--Alexis

Agreed - Every instance I've ever used has allowed both the Custom Field Name or the Custom Field ID to work when querying to see if the field is EMPTY.  Except this one.  

I know that if there are various custom fields with the same name, it will then require the ID to Differentiate, so perhaps that something.  Currently there is:

Team

Team.

TEAM

in the system for one field I am looking to see if is empty, but these should be different enough for Jira to not be confused. NOTE: I’m aware there is some reorganization needed given this example of the Team field isn’t unique in this environment, but that is a different topic and is underway)

A buddy of mine suggested that maybe there is a Nextgen project within this instance that has the Team field, which would cause this one to need the ID.   I’ll look into that and respond back.

appreciate the help!!

0 votes

Hi @Matthew Risch

I recall some Suggestions and Bugs from jira.atlassian.com, something like this one:
https://jira.atlassian.com/browse/JRACLOUD-76536

In your opening post you are referring to field "Story Points" but later you are referring to several spellings of "team" in fields - I don't know if this was just an example?

For the similar bug reports the solution was indeed to use the ID as well.

There is also a report around where "EMPTY" does not return the desired result if the field was previously populated.
https://jira.atlassian.com/browse/JRACLOUD-74027
https://jira.atlassian.com/browse/JRACLOUD-74809
Probably this does not apply here, unless one of the "Team" fields is of type multi-line (Text Field).

Cheers,
Daniel

Suggest an answer

Log in or Sign up to answer
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