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

Problem using date field in call to REST service

Olaf Braxhoofden

We recently upgraded to Jira v7.11.2 and a custom solution built in VBA (Excel) to call the JIRA REST service stopped working. As soon as I use a date field in the JQL statement the GET statement returns a status 400.

It does not matter which date field I use in the JQL, double or single quotes, a fixed date (any format, any separator) or a relative date (e.g. startOfMonth(-1) , endOfMonth(-1), I always get status code 400.

The same JQL statement works fine when copied into the JIRA front end.

As soon as I remove the date field from the JQL selection and only leave things like project, type etc, it works fine.

Any ideas?

Please please

Accepted answers

Alexey Matveev

Hello,

Try to do it in the Rest Api Browser. Have a look if you have a error or not.

You can download the Rest Api Browser from here:

https://marketplace.atlassian.com/apps/1211542/atlassian-rest-api-browser?hosting=server&tab=overview

All comments

Alexey Matveev

Hello,

Try to do it in the Rest Api Browser. Have a look if you have a error or not.

You can download the Rest Api Browser from here:

https://marketplace.atlassian.com/apps/1211542/atlassian-rest-api-browser?hosting=server&tab=overview

Olaf Braxhoofden

Hi Alexey, thanks for taking the time to respond. Unfortunately I am not an administrator in JIRA so I cannot install the utility.

It is a really strange situation.

JQL statement: project = XXX and cf[12090] = 'Production (P)' and type = incident and priority != Nieuw

works

JQL statement: project = XXX and cf[12090] = 'Production (P)' and type = incident and priority != Nieuw and created >= startOfMonth(-1)

Does not work. I get status code 400 but statustext = empty

Before the JIRA upgrade it worked just fine and on the command line in the front end it works fine.

Alexey Matveev

Your JQL parameter should look like this:

jql=project%20%3D%20XXX%20and%20cf%5B12090%5D%20%3D%20'Production%20(P)'%20and%20type%20%3D%20incident%20and%20priority%20!%3D%20Nieuw%20and%20created%20%3E%3D%20startOfMonth(-1)

Olaf Braxhoofden

IT WORKS!!!!!!!

Thank you so much. You have no idea how much you have helped me. I have added a URL encode routine!

Alexey Matveev

@Olaf Braxhoofden You are welcome!

If my answer helped you, kindly accept my answer

Welcome!

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

Quick Links

Find more posts tagged with

jira