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

[Gavin]

Is there a way to query your jira issues.

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

[Daniel Ebers]

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

[Suvradip Paul]

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

[Gavin]

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?

[Suvradip Paul]

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

[Gavin]

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()

[Suvradip Paul]

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