Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Advanced search filter or JQL that finds all tickets whose <custom field> value changed this week

Christine Diamond
Contributor
December 27, 2018

Advanced search filter or JQL that finds all tickets whose <custom field> value changed this week:

This may be a limitation with the product. I was hoping to be able to add a filter to my search that found all tickets whose <doc state> changed values in the past week, like:

"Doc State" changed after -15d

However, this is not supported because Doc State is a custom field. I don't see why I can't report on this. When I look at the history, the date of the change is clearly tracked in the ticket. Why can't I use that data in my filter?

Can anyone recommend how I can get a report like this? 

3 answers

0 votes
PADMA KOTHAKOTA
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 27, 2018

Hi @Christine Diamond,

 

If you want to list out the issue based on the custom field value changed this week (current week) . you can search with the below jql

project = project name and <customFiled> changed AFTER startOfWeek() 

Christine Diamond
Contributor
January 13, 2019

Thanks for trying, Padma. As I mentioned to Raynard, above, these operators are not supported on custom fields. To vote for this issue, see https://jira.atlassian.com/browse/JRASERVER-27641

0 votes
Raynard Rhodes
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 27, 2018
Christine Diamond
Contributor
January 13, 2019

Thanks for trying, Raynard. I don't think those operators support custom fields.  To vote for this issue, see https://jira.atlassian.com/browse/JRASERVER-27641

0 votes
Raynard Rhodes
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 27, 2018

What kind of custom field is it?

Christine Diamond
Contributor
January 13, 2019

I have tried it with these queries and all return "History searches do not support the '<CustomField>' field" error:

  • <CustomField> changed AFTER -15d or 
  • <CustomField> changed AFTER startOfWeek() 

Custom Fields:

  • Doc Required, radio button with three options: None, Yes, No.
  • Doc State, list of values with eight options.
  • Doc Contact, begin typing user name to select a user 
  • Tech Pubs Note, free text field

In fact, I have not found any type of custom field where this did work.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events