The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

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

Cannot filter by "Last Comment" text

Luis Pereira
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 5, 2020

Hello all!!

 

I used to be able to filter by "Last Comment" keyword search, for example 

 

project = "XYZ" AND "Last Comment" ~ "\"<<UDF_UP>>\"" AND "Last Comment Date" <= now() AND "Last Comment Date" >= -10d

 

However, now I get that the "Last Comment" field does not support the CONTAINS operator (~), this worked before we started using Jira Cloud. 

 

Can anyone help me out here? I need to be able to filter text within the "last comment" field.

2 answers

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

1 vote
Gökçe Gürsel {Appfire}
Atlassian Partner
November 5, 2020

Hi @Luis Pereira ,

You can try the Comment Enhancer app to query issues with CONTAINS (~) operator.

All you need to do is to create the Last Comment custom field in your Jira. After creating comment custom fields, add these fields to the relevant screens. Then you'll see that these fields are populated automatically by Comment Enhancer. For historical data, meaning to show data in already existing issues, just perform a regeneration and you're done.

Comment Enhancer custom fields are sortable and searchable.

Last comment.pngcfddd5f0-35a0-47a1-8f23-d62e8e7d91a0.png

59ffa8c5-bb6b-4a87-bf30-44f06d88cac4.png

Please let me know if you have further questions.

Cheers,

Gökçe

0 votes
final_openshift Certi
November 5, 2020

Hi Luic,

You can achieve this by using   JQL Search Extension plugin , you can use the query lcommentedOnDate = "2016/03/14" OR commentedOnDate = "2016/03/13"commentedOnDate in ("2016/03/14""2016/03/13")commentedOnDate < now()

Please refer to the documents it contains examples and other necessary information related to the usage of plugin

Luis Pereira
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 5, 2020

Hello! thank you for your answer....

But how can i look for a specific text within a "last comment" type of field? I used to be able to do this:

 "Last Comment" ~ "\"<<UDF_UP>>\""

But with Jira Cloud it says that "last comment" does not accept the CONTAINS (~). Can you help me with that?

final_openshift Certi
December 1, 2020

Hi Luis,
The options that I posted are made available through a plugin and currently the plugin does not offer this feature

TAGS
AUG Leaders

Atlassian Community Events