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

Date format for script field

d-sokolovskiy

I have created a Date Time Picker script field, Is there anyone can help me remove the Times tamp on my return. Currently field " MM/dd/yyyy hh:mm a (30.04.2018 00:00) " and i will like to get " MM/dd/yyyy (30.04.2018)" this format instead.

Thanks

Accepted answers

Stephen Cheesley _Adaptavist_

Hey,

You can customise the date output using a ScriptRunner script field whilst maintaining the current level of search functionality with use of a "Custom" type field.

1. Create a new script field with the following fields set as specified:

Template: "Custom"

Custom Template:

$datePickerFormatter.withStyle($dateTimeStyle.DATE).format($value)

Here are some useful docs regarding custom templates

Inline Script: (This is for testing purposes, you can put whatever script you want here so long as it returns a date)

def date = new Date()
date.previous()

2. Once you click "Add" to add the new field, you need to change the "Searcher" (see here). If you select it as a "Date Time Range picker" then the value will be searchable from within JQL as a date.

NOTE: Script fields are not updated in the Lucene index until either a re-index is run or the individual issue is updated. Script fields are best used for calculating values based on other values in the issue.

I hope this helps!

Steve

All comments

MoroSystems Support

Hello jiradev,

I think your only option is to implement Text script field and manually convert the date into the format you want. You can take a look at how to do it in this answer by Kristian from Adaptavist: https://community.atlassian.com/t5/Jira-questions/Custom-field-based-on-Priority-created-date/qaq-p/75549

Regards,
Martin

d-sokolovskiy

Hi Martin,
Thank you for your answer. Everything works perfectly! But the problem is that the script field from the Dates section moved to the Details(text field section) on my screen. Do you have any ideas how can this be fixed?

Thanks.

MoroSystems Support

Hm, you are right. There is no control over where the fields are shown (Date ones on the right in Dates panel, People under People and so on). Making the field of text type unfortunately means it will be showed together with the other text ones.

Martin

David Sumlin_4luvfd

It also means that it can't be searched/filtered in JQL using date functions or datepickers.

Stephen Cheesley _Adaptavist_

Hey,

You can customise the date output using a ScriptRunner script field whilst maintaining the current level of search functionality with use of a "Custom" type field.

1. Create a new script field with the following fields set as specified:

Template: "Custom"

Custom Template:

$datePickerFormatter.withStyle($dateTimeStyle.DATE).format($value)

Here are some useful docs regarding custom templates

Inline Script: (This is for testing purposes, you can put whatever script you want here so long as it returns a date)

def date = new Date()
date.previous()

2. Once you click "Add" to add the new field, you need to change the "Searcher" (see here). If you select it as a "Date Time Range picker" then the value will be searchable from within JQL as a date.

I hope this helps!

Steve

Tarun Sapra

Pretty useful, I hope the documentation is updated to include examples like the one which you just shared.

$datePickerFormatter.withStyle($dateTimeStyle.DATE).format($value)

David Sumlin_4luvfd

Thank you Stephen. We use this exact technique!

The only side-effect to this technique that I can see is that the "dates" now will display in the main issue panel. For some users, this is a pro, others a con.

The following statement needs to be in bold AND red AND larger font AND blink! It's important!

If your scripted field is getting values from a db or a JQL search or something besides the issue itself (or I think a linked issue), then you're values will be out of synch with your Lucene index. (lesson learned)

Stephen Cheesley _Adaptavist_

Hey @David Sumlin and @Tarun Sapra

I'm glad my answer was enlightening! If you think that others would benefit from my answer, feel free to mark it as accepted so others can more easily benefit from it.

I believe the indexing detail is already specified in the documentation:

It’s also possible to search on these values if you set up one of the four shipped searchers. If you do, the value is calculated and stored in the index at the time that the issue is indexed, eg when it is modified or transitioned, or when you do a full reindex.

You can only reliably use a calculated field to display a value that is based on the issue’s fields, or subtasks' fields, or linked issues. The reason why is because the value in the Lucene index is only updated when the issue is updated.

Tarun Sapra

Hello @d-sokolovskiy

This feature is now supported out of the box

https://scriptrunner.adaptavist.com/5.4.28/jira/releases/current-release.html

[SRJIRA-2668] - Add a Script Fields Template for Dates without timestamps

Welcome!

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

Quick Links

Find more posts tagged with

jira

adaptavist