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

Hyphen in date custom field name doesnt work in datecompare

Mayuresh Sakharape_ykw1ua

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

Accepted answers

Moses Thomas_08kyb0

@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,

All comments

Ilya Turov

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

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

Mayuresh Sakharape_ykw1ua

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_ykw1ua

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

Moses Thomas_08kyb0

@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,

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-server