Script Fields - Which search template should I use for this format: "1d 12h"?

[Kyle Moseley _blueridge_cx_]

I have a scripted field where I'm returning a duration of time. I went with Xh Xd to keep with JQL's formatting. Is there a way to properliy sort this sort of duration? Number, Text, Date Picker Range aren't working. Any ideas?

[Nic Brough -Adaptavist- · Accepted solution]

I'm afraid the answer is "none of them".  The problem here is that you're representing a number as a string.  Because it's a string, you need a string type searcher, but that doesn't work for searching numerics

The "duration" stuff in JIRA's search and JQL works because it's storing a number in the background and interpreting it into a string for display - in the background, everything is done in numbers, but it talks to the humans in strings.  There is code to do that number <> text translation.

The script runner does not have that functionality (yet.  I seem to remember Jamie mentioned adding it sometime)

I think your best option might be to swap the field to be numeric, and represent hours.  Then you'll be able to search and sort it properly.

[Kyle Moseley _blueridge_cx_]

Okay. It was using a double to represent days (ex: 1.11) with a number searcher. Guess I'll be sticking with that. Thanks.