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

Find all Issues which are not updated by particular user using JQL

Dear All,

 

   Am developing JIRA plugin in that I want to get all Issues which are not updated by particular user. I have the following piece of code. 

JqlQueryBuilder builder = JqlQueryBuilder.newBuilder();
builder.where()
.project(Project.getId())
.and()
.sub()
.issueType("Bug")
.and()
.updatedAfter(date_time)
.endsub();
results = searchProvider
.searchOverrideSecurity(user, builder.buildQuery(), PagerFilter.getUnlimitedFilter());

 The above code gives list of Issues which are in "Bug" type and updated after "date_time"

I want to add one more condition like Last Updated by <> 'Admin'

How to add this condition in JQL Query Builder?

 

Thanks in advance

Eswaran

2 answers

1 accepted

0 votes
Answer accepted

Hi @Eswaran R 

AFAIK, you can't do that with bundled Jira fields. Updated and updatedDate fields both store ast updated date, however there is no field like updatedUser.

I'm afraid, you should use a plugin and add a customfield statement into your JQL.

Since you are developing a plugin you can create a new custom field yourself. It will be a CalculatedCFType custom field. But you need to implement a new searcher/indexer. In the Lucene indexer you need to save authenticationContext.loggedInUser as updating user. Implementing a new searcher/indexer is complex. You need to analyze Jira source code for existing indexers to get an understanding of it.

@Deniz Oğuz Thank you for your suggestion...

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

303 views 1 3
Join discussion

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