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
TAGS

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