Custom Field not displaying/working correctly in Structure

[Robert Tedge]

Hi,

I've created a Jira Structure that pulls in all Risk Issues. We use a custom risk rating field that goes from Very High to Low. To make the Structure properly order risks from Very High down to Low, I've created a new Jira custom field for 'Risk Rating Index' that translates the Risk Rating to a number (because Structure would only sort alphabetically). The field is working as expected and now all risk tickets that have a Risk Rating have a Risk Rating Index.

However, the field is not properly showing in the structure properly so it can't sort properly either. When I add the Risk Rating Index as a column, only some issues show the Risk Rating Index value  even though all Risk Issues have the value if I go and look at the actual issue. 

I cannot work out why this is happening. 

[Ignacio Pulgar · Accepted solution]

Hi @Robert Tedge ,

Provided that the number of custom fields has an impact on Jira instance's performance, I'd prefer to use a Sort Automation in Structure this way:

1. Click on the + button next to Automation > Sort > Attribute...
2. In the Order by dropdown, select Formula...
   
3. Insert this formula and click on Apply button:

CASE(riskRate;
"Very High"; 1;
"High"; 2;
"Medium"; 3;
"Low"; 4
)

Hope it helps.

[John Funk]

Hi @Robert Tedge  - Did this provide the solution you needed?

[Liam Green]

Hi @Robert Tedge 

Welcome to the Community!

If Jira Structure refers to the add on app, it might be worth reaching out to the developer directly.

Hope that helps,

Regards, Liam

[Robert Tedge]

Thanks Liam, I should have been clearer, I am referring to the Structure add on. I'll see how I can get support from the developer. 

[Dave Rosenlund _Trundl_]

Hi, @Robert Tedge. Just hit us up at alm.works/support -- or if you prefer, support at almworks.com

-dave [ALM Works]

[Martin Bayer _MoroSystems_ s_r_o__]

Hi @Robert Tedge can you display the value of the field in Issue Search (top menu -> Issues -> Search for issues)?

[Robert Tedge]

Hi @Martin Bayer _MoroSystems_ s_r_o__, I can see the value in issue search. I think it must be an issue with the add on. 

[Martin Bayer _MoroSystems_ s_r_o__]

Ok so then probably the best thing to do is to use ALM support as @Liam Green  suggested ;)

[Prince Nyeche]

Hi @Robert Tedge 

It's always good to use the proper Jira terms when posting questions on community in order for the people who wants to help to quickly know what you're referring to. Now "Jira Structure" - what does this mean? Are you referring to a filter or a JQL query. I cannot understand what you mean by that.

furthermore, if i tried to guess what you mean here, I would rather put it that, you've made a two custom fields and you're trying to sort it on a filter based on the value of one of the custom field. Please elaborate properly or use images to depict what you mean for clarity.