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

[Hamish Page]

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?

[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]

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.