Target end date from portfolio cannot be used in issue filter

[kedar pan]

I am trying to use target end date from portfolio to find out which issues have been updated in last 5 days. I don't think i can use JQL search as JQL does not allow date compare. I am looking for scriptrunner options but require some suggestion to best implement it. Any suggestions.

[Ste Wright]

Hi @kedar pan 

You should be able to use it - a simple JQL like this should work...

"Target end" < startOfDay()

I have found it doesn't work with Scriptrunner though, if using dateCompare. It's because technically Target End Date isn't a date field in Jira - it's a Target End field type.

To circumnavigate this - I usually either...

• Use Due Date with Advanced Roadmaps instead
• Create custom fields to replace Target End/Start in Advanced Roadmaps
  • To be clear - I'm modifying the dates per plan using these instructions
• Create custom fields for use in JQL, copying the data from Target End/Start into them

Ste

[kedar pan]

@Ste Wright I might have misstated my question. i am trying to setup a filter that gives me insight of anything that was updated in target end field irrespective of dates. Lets say someone updates an Epic yesterday with target end date 04/01/2022, i want to see them as a change happened in that field and should show up in the filter.

[Ste Wright]

Hi @kedar pan 

Could you provide an example of your current search filter?

It sounds like you're looking for a filter to show you how many Target End Dates were modified in a time period (irrespective of the date in the field itself)? Is that correct?

Ste

[kedar pan]

@Ste Wright Correct. I am not concerned about the date value. I just need to know which issues have target end date changed in last 5 days.

[Ste Wright]

Hi @kedar pan 

This isn't possible using native Jira - a small number of system fields can use history searching for this, but this doesn't include Target End

The included fields are Assignee, Fix Version, Priority, Reporter, Resolution, and Status.

---

As far as I've seen, it's not possible with more advanced JQL Apps either. What you'd need to do is...

• Create a date picker custom field - eg. TE Updated
• Use a scripting or automation App to populate the custom field each time Target End is updated with today's date
• Query against that field - eg. "TE Updated" > -5d

---

Options for updating the custom field include...

• Scripting Apps like Scriptrunner
• Automation Apps like Automation for Jira - this is becoming native functionality soon in Data Center - see the roadmap for more information

Ste

[kedar pan]

@Ste Wright is there a way you can guide me with the setup using scriptrunner? 

[kedar pan]

@Thanos Batagiannis [Adaptavist] can you or other adaptavist guys help me out here. Any help is much appreciated. I am looking to setup a listener to update custom field with current date when changes happen to target end date.

[Ste Wright]

Hi @kedar pan 

I'm not sure exactly how to do this one - you could possibly use a scripted field, or a listener?

I'd suggest you try to contact Adaptavist Support for assistance - see contact options here: https://marketplace.atlassian.com/apps/6820/scriptrunner-for-jira?hosting=server&tab=support

Ste