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

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

Jira - query if text entered exists from the reporter in an issue

Is there a way to query your jira issues.

If the reporter in an issue has entered text "completed"?

2 answers

Hi @Gavin ,

Thanks for posting in community.

I think you try with with the below mentioned :

  1.  Just typing in Search - completed
  2. Searching in JQL - Depending on the exact field I have mentioned these options like description and field.
    • reporter = "reporter_name" and text ~ "completed"
    • reporter = "reporter_name" and description ~ "completed"
    • reporter = "reporter_name" and summary ~ "completed"

Please accept the answer if it solves your query. Else, please respond and allow others to share inputs.

Cheers

Suvradip

Thanks Suvradip!  That helps.  But how do you query if the reporter in the issue itself has added text completed.  The query although great is still requiring the reporter to be specified. 

Is there something like currentuser() value for reporter for an issue?

Thanks @Gavin  for your quick response.

Yes, if reporter like to view it would be either one of these -

  1. reporter = currentUser() and text ~ "completed"
  2. reporter =  "reporter_name" and text ~ "completed"

Just type in the reporter name in case of the later one, the result would be same.

Cheers

Suvradip

Sorry for not being more clear.

I was trying to figure out a way to check if the reporter of an issue entered text (completed) within the issue they were reporting. 

Is there a way to find out that without entering the name of the reporter or current user()

Thanks @Gavin  for response.

  1. Can you simply try this for generic search - text ~ "completed" ?
  2. If you wish to fine tune a bit and aware of project and labels then please try project =xxx and labels =zzz and text ~ "completed"
  3. If the word was used in summary then you can try - summary ~ "completed" or if it was used in description then try description ~ "completed"
  4. Or a mix of point 2 and point 3 - project =xxx and labels =zzz and summary ~ "completed" or project =xxx and labels =zzz and description ~ "completed" 

Please accept the answer if that solves your query else respond and let others to share input.

Cheers

Suvradip

0 votes
Daniel Ebers Community Leader Jul 11, 2021

Hi @Gavin

are you using Jira Cloud or Jira Server?
When using Cloud you could use an Automation rule during issue create which sets a custom field to a value of your choice IF during Issue Create "completed" was entered in, for example, Description.

Then you could tackle this using JQL.

I would be happy to assist with an Automation rule and try to test things out - it should work, but first of all two questions:
1.) do you have Jira Cloud where we could use this kind of Automation
2.) has your question yet been resolved by Suvradip? I have seen many good approaches and recommendations, however it is not fully clear if you have still questions after the JQL queries that were suggested.

Thanks in advance!

Regards,
Daniel

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