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

Get Version Release date in specific format

Yogesh Mude_qi979c

Hi Team,

Currently, we have a requirement to show only the last 30 days of released versions only, if any version does not contain the release date then ignore it.

I am able to get the version release date in the yyyy-MM-dd HH:mm:ss for example release date: 2018-09-24 00:00:00.0 format but as i need to compare it with yyyy-MM-dd format so i am unable to do so and getting the below error.

java.lang.IllegalArgumentException: Cannot compare java.sql.Timestamp with value '9/24/18 12:00 AM' and java.lang.String with value '2021-05-15' at Script2778$_run_closure1.doCall(Script2778.groovy:22) at Script2778.run(Script2778.groovy:17) Caused by: java.lang.ClassCastException: java.lang.String cannot be cast to java.util.Date ... 2 more

Any help will be appreciated.

Thanks

Accepted answers

All comments

Ram Kumar Aravindakshan _Adaptavist_

Hi @Yogesh Mude,

Could you please share the full code you are using?

Also, for the Date formatting, have you tried using the java.text.SimpleDateFormat?

Thank you and Kind Regards,
Ram

Yogesh Mude_qi979c

Hello Ram,

Thank you for the response.

Yes, i used java.text.SimpleDateFormat.

import java.text.SimpleDateFormat
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.project.version.Version
import com.atlassian.jira.project.version.VersionManager


//get last 30 days date
Calendar cal = Calendar.getInstance()
cal.add(Calendar.DAY_OF_MONTH, -30)
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd")
def last30Days = sdf.format(cal.getTime())
log.error "Date : ${last30Days}"

def vers = ComponentAccessor.getVersionManager().getVersionsReleased(14644, false) //project ID
def dateVersions = []

vers.each { version ->
def releaseDate = version.getReleaseDate()
log.error " release date: " + releaseDate
def rel = sdf.format(releaseDate)
def released = version.isReleased()
if (released == true && releaseDate <= last30Days){
dateVersions.add(version)
}
}

Ram Kumar Aravindakshan _Adaptavist_

Hi @Yogesh Mude,

The reason why you are encountering the exception is that there is an error in your parsing configuration.

On this line:-

def last30Days = sdf.format(cal.getTime())

You are passing the value for the last 30 days as a String, and when you are making the comparison between your release on this line:-

if (released == true && releaseDate <= last30Days){

you are comparing a String to a Date which is what causes the exception.

You should instead pass the value as a Date like this:-

import com.atlassian.jira.component.ComponentAccessor
import java.text.SimpleDateFormat

def versionManager = ComponentAccessor.versionManager

def cal = Calendar.instance
cal.add(Calendar.DAY_OF_MONTH, -30)

def sdf = new SimpleDateFormat("yyyy-MM-dd")
def last30Days =  sdf.parse(sdf.format(cal.time))

def vers = versionManager.getVersionsReleased(10600, false) //project ID
def dateVersions = []

vers.each { version ->
    def releaseDate = version.releaseDate
    log.warn " release date: ${sdf.format(releaseDate)}"
    def released = version.isReleased()
    if (released && releaseDate <= (last30Days as Date)){
        dateVersions.add(version)
    }
}

Please note, this sample code is not 100% exact to your environment. Hence, you will need to make the required modifications.

Below is the test output with the updated code:-

If you notice in the print screen, the log printed for the Date uses the yyyy-MM-dd format.

I hope this helps to answer your question.

Thank you and Kind Regards,
Ram

Yogesh Mude_qi979c

Hello @Ram Kumar Aravindakshan _Adaptavist_

Thank you so much for your response.

I did the changes to the code and ran to the script console.

I got the response as below snapshot.

import java.text.SimpleDateFormat
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.project.version.VersionManager


//get last 30 days date
def cal = Calendar.getInstance()
cal.add(Calendar.DAY_OF_MONTH, -30)

def sdf = new SimpleDateFormat("yyyy-MM-dd")
def last30Days = sdf.parse(sdf.format(cal.time))
log.error "Date : ${last30Days}"

def vers = ComponentAccessor.getVersionManager().getVersionsReleased(14644, false) //project ID
def dateVersions = []

vers.each { version ->
def releaseDate = version.getReleaseDate()
log.error " release date: " + sdf.format(releaseDate)

def released = version.isReleased()
if (released && releaseDate <= (last30Days as Date)){
dateVersions.add(version)
}
}

If I am not wrong is this error due to some of the versions does not contain the release dates?

Welcome!

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

Quick Links

Find more posts tagged with

server

scriptrunner

jira

jira-server

script

format