Change date/hour format in queues

fran.quintero

Hi all!

I have a date-hour picker, "Change start date", that I use as a custom field in a screen. As an agent I want to see in queues a column with the info of that "Change start date", but it shows me how much time is left (see attached file).

My question: Is there a way to see just the date-time that the reporter put on that custom field, and not the time remaining?

 

Thanks!

Nick Hassell

I don't think you can do what you want (exactly).

If you have ScriptRunner, then read on...

I had the same issue, and created a custom text field.  I wrote a Script Listener that ran whenever the issue was changed, which populates the text field with a string representation of the 'Change Start Date'.  In my queues, I display the text field, but order by the date field.

If you are interested, here is my code (this board seems to have lost my spacing):

// Jira Service Desk queues show dates as relative (e.g. tomorrow) and do not show time
// This script creates a text string representing the absolute date and stores the string
// in a hidden text field for displaying in the queues

// Get the list of custom fields
def customFields = get("/rest/api/2/field")
.asObject(List)
.body
.findAll { (it as Map).custom } as List<Map>

// Get the values of interest from the current issue. 
def startRelId = customFields.find { it.name == 'Change Start Date' }?.id
def startRel = "" as String
if (issue.fields[startRelId] != null){
startRel = issue.fields[startRelId]['value'] as String
} else {
logger.warn("Start date not set.")
return
}
def endRelId = customFields.find { it.name == 'Change End Date' }?.id
def endRel = "" as String
if (issue.fields[endRelId] != null){
endRel = issue.fields[endRelId]['value'] as String
} else {
logger.warn("End date not set.")
return
}

def startAbsId = customFields.find { it.name == 'Change Start' }?.id
def startAbs = "" as String
if (issue.fields[startAbsId] != null){
startAbs = issue.fields[startAbsId]['value'] as String
}
def endAbsId = customFields.find { it.name == 'Change End' }?.id
def endAbs = ""
if (issue.fields[endAbsId] != null){
endAbs = issue.fields[endAbsId]['value'] as String
}

def curStartAbs = getFormattedDateTime(startRel)
def curEndAbs = getFormattedDateTime(endRel)

if ((startAbs != curStartAbs) || (endAbs != curEndAbs)){
// At least one of the dates has changed (or is newly set)
setAbsDate (startAbsId, curStartAbs, endAbsId, curEndAbs)
logger.info ("Absolute dates updated.")
}

// ------------------------ END OF SCRIPT -----------------------------//

// This method creates a formatted date / time string
String getFormattedDateTime (String datetime){
Date startDate = Date.parse( "yyyy-MM-dd'T'HH:mm:ss.SSSZ", datetime )
def formattedDate = startDate.format("EEE dd MMM")
def formattedTime = startDate.format("HH:mm")
return formattedDate + ' ' + formattedTime
}

// This method sets the text fields with the supplied values
Void setAbsDate (String startAbsId, String startAbsDate, String endAbsId, String endAbsDate){
put("/rest/api/3/issue/${issue.key}")
.header("Content-Type", "application/json")
.body([
fields:[
(startAbsId) : startAbsDate,
(endAbsId) : endAbsDate
]
])
.asString()
return
}