Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

I want to see customfield usage ( how many times customfield was filled )

Nikishin Aleksandr February 9, 2017

I want to see customfield usage ( how many times customfield was filled ).

How can i do this?

2 answers

1 accepted

0 votes
Answer accepted
Nikishin Aleksandr February 12, 2017

select customfield, COUNT (customfield) AS NumCustomusage from customfieldvalue

group by customfield HAVING ( COUNT(customfield) > 1 )

0 votes
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 10, 2017

Run a search for "custom-field is not empty"

Nikishin Aleksandr February 10, 2017

I mean make table like this.

Customfield | count of usage.

                    |

                    |

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 10, 2017

You'll need to write code to do that in JIRA.

Suggest an answer

Log in or Sign up to answer