nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do you display the value of a custom field as a column

Ste404

Hi there,

I am baffled as how to do something in a very basic chart in Analytics.

I can see in the Issue field table all the custom field names in the Name column. I can set up a filter in a query using this information by filtering for a Name and a Value =.

BUT what I want to do is show the values for issues of a custom field..

Issue Key, Summary, Assignee, Custom field 1, Custom field 2 etc.

How do I add them as a column in the output. If I click Add column and then search for column name the custom fields do not return to be able to be added.

What am I missing here?

Thanks

Accepted answers

Matthew Lempitsky

Hi Steven!

Thanks for your question.

You're on the right track with regards to setting up a filter with the Name and Values for the custom fields in the Issue Field table. You can read more about that filtering here.

The trick is that each custom field you wish to add to your result set, will need to be it's own query. You can add additional queries to your main query and then choose the join type.

Here is a quick example of how you could add to custom fields to your main result set:

Hope this helps!

All comments

Matthew Lempitsky

Ste404

ooohh I was so close, was trying to do that exact thing but in the one query which obviously wasn't going to happen.

Thanks for that, makes sense now that I see it and have mocked one out myself.

Ste404

One question. I have this basic query that produces a bar chart, simple enough.

I have a custom field called ContractOrgs and I want to filter these results to only be three of these specific companies in the list, where do I put the name and value option for that field in this chart setup.

Matthew Lempitsky

Hey Steven,

Instead you can apply that filter in the Custom Field query and by using an inner join instead of a left join.

So, in your query where you are returning Contract Orgs, you can add a filter for value is one of (Org1, Org 2, Org3)

Then by changing to an inner join only rows where the value matches is one of (Org1, Org 2, Org3) will be added to the result set