Jira search isses

Question

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_v50vis · Answer

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

Thomas B · Answer

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”

Toby Moore_v50vis · Answer

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?