Community
Q&A
Jira Service Management
Questions
Scriptrunner script to validate difference between start and end time is not more than 3 months

Scriptrunner script to validate difference between start and end time is not more than 3 months

Hi Team,

I am working on scriptrunner on JSM data center.

I am looking for a Scriptrunner script to validate difference between start and end time is not more than 3 months

Please advise.

Thanks

3 answers

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

3 votes

Answer accepted

Hi @Minu Murali,

You can get difference b/w 2 days by normal subtraction

endDate - startDate

or you can use below method too

//assume you fetched start and end dates already
startDate.setMonth(startDate.getMonth() + 3)
if(endDate > startDate){
   //end date is 3 months greater than start Date
}else{
   // end date is less than 3 months
}

hope this helps

BR,

Leo

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Hi ,

I have to add one more condition to the above snippet which is to ignore a particular request type.

When I combine this condition with the above condition, it is not working.Both of them are working successfully if added separately.

import com.atlassian.jira.component.ComponentAccessor

def cfm = ComponentAccessor.getCustomFieldManager()
def start = issue.getCustomFieldValue(cfm.getCustomFieldObjectsByName("Start Date")[0])
def end = issue.getCustomFieldValue(cfm.getCustomFieldObjectsByName("End Date")[0])

def cf = ComponentAccessor.customFieldManager.getCustomFieldObjectByName("Customer Request Type")
def requestType = issue.getCustomFieldValue(cf)

start.setMonth(start.getMonth() + 3)
if ((requestType.toString != “ims/b3270e4e-6b55-4e59-b58e-8d2720a10905”) && (end > start)){
return false
}else{
return true
}

Could you please tell me why this is not working?

The expected result is if the request type is equal to the given one, it should go to else and return true.

But it still goes to check the start and end condition. ( we do not have start and end dates in this request type form)

Thanks!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Hi Leo,

Thanks for the prompt reply. I am fairly new to ScriptRunner so I am having difficulties.

I tried the above script but do not understand what to change where?

I managed to get this working almost 90%.

cfValues["End Date"] - cfValues ["Start Date"] <=3

is what I am using. However the 3 is defaulting to 3 days. How do I make it 3 months. ( and both my custom fields are Date and Time fields).

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

you may need to add couple of lines to include given mechanism. can you try below snippet

import com.atlassian.jira.component.ComponentAccessor

def cfm = ComponentAccessor.getCustomFieldManager()
def start = issue.getCustomFieldValue(cfm.getCustomFieldObjectsByName("Start Date")[0])
def end = issue.getCustomFieldValue(cfm.getCustomFieldObjectsByName("End Date")[0])

start.setMonth(start.getMonth() + 3)
if(end > start){
     return false
}else{
     return true
}

BR,

Leo

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • Alex Koxaras -Relational- likes this

Thanks a ton @Leo . This worked perfectly well.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Was this helpful?

Thanks!

Jira Service Management

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Scriptrunner script to validate difference between start and end time is not more than 3 months

3 answers

1 accepted

Comments for this post are closed

Was this helpful?

Thanks!

TAGS

Atlassian Community Events