Sorting Troubles, Custom Text Field

[David Childers]

Hello all,

I've created a custom field "Stakeholder" to tag each of my tickets with the correct department.  I have an "all open tickets" filter I use to review tickets each day with the Org, department by department.

A week or so after I started this process, I opened the same filter I've been using the whole time, and now the filter sorting is wonky - despite no changes to the custom Stakeholder field, it seems to sort however it wants :D There will be a couple tickets grouped on the same dept/stakeholder, then a seemingly random set of mixed stakeholder tickets...

Pretty awkward in the meetings trying to explain to C-Suite why I have to scroll around randomly to stay on department/stakeholder :(

I had to abandon the Filter approach and use a custom Issues view.  Personally, I like both, but the Filter is more user friendly UI for the audience I'm presenting to - would prefer to stay with the Filter if I can get the sorting worked out.

Anyone have experience with this issue and hopefully a fix?

[Bill Sheboy]

Hi @David Childers 

What is the type of your Stakeholder, custom field: single-select option, text, etc.?

And, please share the JQL you tried as that may help to explain this symptom.  Thanks!

Kind regards,
Bill

[David Childers]

Argh, this UI is fighting me...

Single-Select Option, purely text values.

Tried plain vanilla Filter (project and in openSprint) and ordering still wonky.

Checked select values for spaces or goofy characters but all seem sound.

[David Childers]

[David Childers]

[Bill Sheboy]

Thus your JQL query looks something like this with the ORDER BY keyword, correct?

project = MYPROJECT
 AND sprint IN openSprints()
 ORDER BY Stakeholder ASC

[David Childers]

That is correct sir!

[Bill Sheboy]

And with that ORDER BY clause, the returned work items are not ordered by that field consistently?

Is the field single-selection or multiple-selection?

From where are you viewing / sorting the work items?

• the "List" view from within a project
• the "Search work items" view which allows using any JQL query
• somewhere else

[David Childers]

• Correct, with that simple JQL, I get seemingly random sorting (see image I posted earlier)
• Single selection
• Viewing from a Filter

Thanks Bill!

[Bill Sheboy]

Please post the actual JQL you are using as neither the column title (i.e., custom field name) nor the options shown match for the images relative to your question.

That is...

• you note a "Stakeholders" field, but the column name appears to be "Meteor..."
• the work item list shows values of "Revenue Op...", "Quoting", etc. and those are not shown as values configured for the custom field.

Thank you!

[David Childers]

project = MYPROJECT and Sprint in openSprints() order by cf[10401]

Jira converts the text title to the custom field ID looks like.

LMK if that helps!

[David Childers]

Meant to add: I didn't post the entire list of values, only a snip for visual.

[Bill Sheboy]

Please try adding "ASC" or "DESC", as needed for your query, because as the documentation notes for ORDER BY when neither is specified:

By default, the field's own sorting order will be used. You can override this by specifying ascending order ("asc") or descending order ("desc").

[David Childers]

Here's a screenshot of the experience (including explicitly using ASC):

[Bill Sheboy]

Unless your site was originally converted to Cloud from a Server / Data Center one, I am out of ideas for this one.

Please work with your Jira Site Admin to submit a ticket to Atlassian Support as they may see something we are missing: https://support.atlassian.com/contact/#/

When you hear back from them, please post what you learn to benefit the community.

[David Childers]

Thanks Bill, submitted ticket via link you provided.

If I receive a fix, I'll post it here.