why can I not colour cards without a story point value

[Gemma FRENCH]

Before we moved to JIRA Cloud, I had JQL set for colouring cards which didn't contain a value in field 'story points'. 

Since migrating over, the JQL doesn't work.  See below. 

"Story Points" is EMPTY 

[Nic Brough -Adaptavist-]

Welcome to the Atlassian Community!

That should still work, but could you have a close look at the list of custom fields and check that you only have one Story Points field?  Also, maybe try "Story Points" = 0

[Gemma FRENCH]

I have tried thisbut it is not helpful as we use the value '0' 

it's the cards that are not populated I am looking to identify.

[Nic Brough -Adaptavist-]

Ok, that makes sense.

But I get exactly what I expect from 

• "Story Points[Number]" is empty
• "Story Points[Number]" is not empty
• "Story Points[Number]" = 0

All I can think of is that you have a second field called "Story points" that is not a numeric field.

[Gemma FRENCH]

I have used the above, and though it allows me to enter the JQL 'is empty' it doesn't colour the cards which are not populated. The JQL 'is not empty' does work and colours all the cards with a value.

Maybe a silly question, but how do I find that? I only see one field when I click 'create new issue'. 

[Nic Brough -Adaptavist-]

Sorry, how do you find what?

[Gemma FRENCH]

The potential second story point field you refer to above. I have checked the issues and only 1 'story points' field is visible. 

[Nic Brough -Adaptavist-]

Ah, ok.  There are two places to look - the easy one is admin -> issues -> fields and simply look at the list of custom fields for anything like "story points".

The more painful one is that you need to go into admin for every team-managed project and look at the field settings individually.

There is another option that can identify a field though.  Go to search and into the "advanced search".  Start typing "story points" and pause after a few keystrokes - the autocomplete should kick in, by offering a drop-down list of all the fields starting with names starting with "stor..." - how many does it offer?

[Gemma FRENCH]

2 return. 

1 numerical and 1 dropdown

[Walter Buggenhout]

Hi @Gemma FRENCH and welcome to the Community!

Try composing your JQL in the issue navigator (Filters > Advanced search). In cloud, Jira has the strange habit to convert your field names into something that also has the custom field type attached to it. Run your search and see what it does to your JQL. In my test instance, this is the equivalent that does work:

"Story Points[Number]" is EMPTY

Hope this helps!

[Gemma FRENCH]

Thank you, the advanced search pulled through cards which didnt have story points... however, none from my board which I find strange. These were all either EPICS or Zephyr tickets. 

I tried the above on the board settings too but this didn't change the result. I tried a few variations and I received the following: 

Operator 'is' does not support searching for non-empty values for field 'Story Points[number]'.

Any ideas how this can be changed to it located the cards without storypoints populated? 

[jamie_slater]

in a team managed board you have "story point estimate" instead of "story points"