Jira search isses

[Toby Moore]

Hi all,

im trying to use the below query

project = SPL AND status changed to “In Implementation” during (2018-01-01, 2018-02-01)

but its just giving me this error

'Error in the JQL Query: Expecting either 'OR' or 'AND' but got 'Implementation”'. (line 1, character 41)'

any ideas why? I ran it earlier and it worked fine...

EDIT: I've just re-created this query from scratch and the below works

project = SPL AND status changed To "In Implementation" during (2018-01-01, 2018-02-01)

no idea whats going on

[Toby Moore]

Are there any Jira admins who can confirm if this is an issue or not?

[Thomas B]

Not sure why that error would occur. I've noticed this error in the past too. To avoid errors, I use the JIRA system drop down to select any suggested values it may have instead of free-typing the filter. 

Mine worked fine: project =  "Project Creation" AND status changed TO Done DURING (2018-01-01, 2018-02-01)

Glad it is fixed! 

[Toby Moore]

Yeh its really weird, my colleague sent me a query that worked for her, but it wouldn't work for me.

I then sent her my working query, but that wouldn't work for her, I then re-ran that exact query later and it then wouldn't work for me!!

The above was all copy and paste so no difference at all.

I wonder if we both suffer from the same problem? "In implementation" and "Project Creation" both contain words that are Jira statements ("In" and "Project"). Could it be that the advanced search isn't handling "n" correctly?

[Thomas B]

Hopefully someone else will respond to this last question you surfaced. I think you may be onto something because 'Error in the JQL Query: Expecting either 'OR' or 'AND' but got 'Implementation”'. (line 1, character 41)'. This line in bold makes me think that JIRA recognized 'In' as a function instead of an actual workflow value.

If JIRA recognized the "In Implementation" it would say  'Error in the JQL Query: Expecting either 'OR' or 'AND' but got 'In Implementation”