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; } } }

Jira Cloud for Sheets Returning 500 Server Error when trying to order by Custom field.

Hamish Page_gdehwo

Could be any custom field, in this case using a start date.

JQL code "=Jira("Project=Discovery order by cf[10055] asc")"

Currently returning 500 Server Error.

If i dont use the cf[xxxxx] then i can filter by something like 'created' and it works so I am correctly receiving data, just not when trying to sort by a custom field.

Is this a limitation to Jira cloud for sheets? or am i doing something wrong?

Accepted answers

All comments

Aron Gombas _Midori_

What happens if you use the name of the custom field in the CQL query?

Something like:

JQL code "=Jira("Project=Discovery order by MyCustomFieldName asc")"

Hamish Page_gdehwo

Same thing, i get an 500 Server Error,

I did some further testing and i think it is the Date field specifically. If I filter by a different custom field (checkbox being checked or not) it works.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud