Hyphen in date custom field name doesnt work in datecompare

[Mayuresh Sakharape]

Hi,

We want to use datecompare in JQL function with customfield dates.

The date field name is Q-Date.

The JQL looks like

issueFunction in dateCompare("","QA Date> Q-Date")

'-' is considered as minus. and get below error

"Scripted function "dateCompare" compilation failure. Contact administrator and check logs. Message: Field name: Q not found or not a date or datetime."

How to esacpe the hyphen in customfield name

[Moses Thomas · Accepted solution]

@Mayuresh Sakharape   I have the solution for this problem once you are login in as admin  got to customfield setting to  get the custom field id's  of  the dates  field in order to compare them

Custom fields > search for field name > edit and you will find the id on the browser link.

Now  with the script runner plugin ( latest version) type the query below.

issueFunction  in  expression ("",  "customfield_id1 > customfiled_id2")

Kind regards,

Mo

[Ilya Turov]

just quote fieldnames(with a single quotes inside, if outside are double)

issueFunction in dateCompare("","'QA Date' > 'Q-Date'")

[Mayuresh Sakharape]

Hi Ilya,

It doesnt work. After quotes, it doesn't even identify first date field.

[Ilya Turov]

yeah, it's weird

they also recommend using customfield_12345 instead of field name, if it contains any "punctuation", but I also couldn't get it to work

[Mayuresh Sakharape]

yes, its not working. I tried it with customfield_12345 or cf[12345]. But no success.

[Moses Thomas]

Dear Adaptivist,

Please could you solve this issue ?

Has any one solved this issue ? i think that this is a bug

Best regards,

Mo