What does cf[13524] mean in the query? How to find it out what does the number stands for?

Lawrence
Contributor
February 6, 2021

I look at some of peoples query contains  "cf[xyzvw]", where x, y, z, v, z are digits between 0 and 9. What does those number 'xyzvw' represent? Why people use those number in the "cf[]"? How to find out the mean of those numbers as a non-administrator?  For example,

project = 15100 AND issuetype in ("Defect TRACKER") AND status in (Submitted, Assigned, "Defect Submitted", Accepted) AND cf[14836] in ("CS 09.0.00", EMPTY)

Thank you,

Lawrence

 

 

 

 

1 answer

1 accepted

1 vote
Answer accepted
Hana Kučerová
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 6, 2021

Hi @Lawrence ,

xyzvw represents custom field id. You can either use this id or custom field name in JQL.

If I'm not Jira administrator, I use REST API to get basic information about custom field.

After you log in to Jira, insert this URL to the browser:

https://your-instance-url/rest/api/2/field

You should get JSON with custom fields and if you search xyzvw through these data, you should be able to find your custom field's properties.

Hana Kučerová
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 6, 2021

Why people use those numbers? Because custom field's name can change, but id is still the same, so I believe, this is the main reason.

Like # people like this
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 6, 2021

 

If you did a bit of digging, you would indeed find that the numbers are immutable database entries.  You can change the name of something but not change the unique id for it.  I'd recommend not bothering to do that digging, it's exactly what @Hana Kučerová  has said

Lawrence
Contributor
February 6, 2021

Hana provide me the tool to see what's hidden behind the number.  Thank you all for your time in helping in knowing cf numbers.

Regards,

Lawrence

Suggest an answer

Log in or Sign up to answer