Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to create ticket automatically on basis of custom field value.

Hi 

I want to create a new ticket automatically, after 6 months of "Date of Joining"(Custom field).

Could anyone help me with this.

2 answers

1 accepted

0 votes
Answer accepted

You could use Automation for Jira to run a query every night searching (using JQL) for issues where Probation Complete Date was 6 months ago AND does not contain a linked issue to whatever new issue type you are making. If it finds any then create the linked issue.

So its not really a "listener". Just looks every night to see if there is anything to do, and then does it. You just want to make sure to have a way to filter out the tickets that have already been acted on.

Hi @Andrew Laden  Could you please elaborate as i am not having much knowledge in automation.

we have only "date of joining" custom field and user will enter this date.

Now after 6 months of "date of joining" new issue has to create.

Do you have the Automation for Jira Addon?

https://marketplace.atlassian.com/apps/1215460/automation-for-jira-server?hosting=server&tab=overview

You would need the full version to create new issues.

Yes I have Automation jira addon.

@Andrew Laden  In automation, on scheduled trigger we are writing this JQL 

project = TEST AND issuetype in standardIssueTypes() AND "Date of Joining" >= startOfDay(-1d)

 

and "Fixed rate of every" 10 minutes i have given.

but it is not working properly.

When you say it is not working properly, what is going wrong? 

as a guess, Check the following.

In the Scheduled trigger, just below the JQL field, there is a "Validate Query" link. If you click on that, does it show the issues that you would expect to see? If not, you need to fix your JQL till you get it to show what you would expect.

Also check the "scope" of your automation rule. Under Rule Details, make sure the its either a global rule, or that both the project you are searching and the project you are trying to create the ticket in are listed.

Other then that I would need more detail as to what is not working.

Like kanishka likes this

Thanks @Andrew Laden for response. 

We got the correct JQL.

Great. Dont forget to mark the answer as accepted

What was your final JQL out of curiosity?

@Andrew Laden 

1. Scheduled everyday with JQL 

Project = Test AND issuetype = "Service Request" AND "Date of Joining" = startOfDay(-165d)

2. Gave condition to check it has linked issue or not.

3. If not, create linked issue.

Like Andrew Laden likes this
0 votes
Ismael Jimoh Community Leader Jul 13, 2020

You can use scriptrunner add-on for this.

  1. Add a create issue post function 
  2. Add a checker to see if the field is populated 
  3. Add a create issue event specifying which project the issue should be created in. See video sample: https://m.youtube.com/watch?v=UT_qche3kc4

Cheers.

Hi @Ismael Jimoh  Thanks a lot for quick reply.

actually I want to create issue automatically after completion of 6 moths from "Date of joining" which is custom fields. (means when probation complete)

 

I tried :

Created scripted field "Probation Complete Date" which will calculate 6 months from "Date of Joining"

Created Listener to create new issue.

 

But when should i call this listener. 

How it will calculate 6 months automatically.

 

Please help me with this.

Like Mahesh Kallepalli likes this
Ismael Jimoh Community Leader Jul 13, 2020

Hi @kanishka 

I’m not sure how your date field would function but of you can use JQL to search for it, you can use the Escalation job to trigger issue creation based on value of your date field.

See a sample here: https://scriptrunner.adaptavist.com/latest/jira/escalation-service.html

Unfortunately, I don’t have a laptop with me to help explain this in more details.

Regards.

Like # people like this

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Service Management

Why upgrade to Jira Service Management Premium?

We often have questions from folks using Jira Service Management about the benefits to using Premium. Check out this video to learn how you can unlock even more value in our Premium plan.  &nb...

182 views 1 6
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you