CommentedOnDate = startOfWeek() and commentedOn , commentedBy is not working

Mohan Reddy Kotla
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!
December 22, 2024

I am looking for the filter all the issue / FR commented by the team in the current week. but not working 

CommentedOnDate = startOfWeek() and commentedOn , commentedBy is not working

2 answers

0 votes
Marc - Devoteam
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 23, 2024

Hi @Mohan Reddy Kotla 

This works fine.

See example: 

commentedOnDate <= startOfMonth() and commentedBy = currentUser()

What is your JQL clause?

Mohan Reddy Kotla
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!
December 23, 2024

@Marc - Devoteam 

I tried with this JQL Query type IN (Defect,"Feature Request",Subtask,"Sub-task","Content Issue", "Content Defect","Content Maintenance") AND commentedOnDate <= startOfMonth()AND commentedBy = currentUser()

Getting error message  as "Field 'commentedOnDate' does not exist or you do not have permission to view it."

Marc - Devoteam
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 23, 2024

Hi @Mohan Reddy Kotla 

This requires a marketplace app "JQL Search Extensions"

I forgot I have it installed on my instance.

Native it should by the JQL function "commentedOn"

By aware that the functions commentedOn and commentedBy are not coming the values used.

So setting a certain user in commentedBy will get all issues commented by that user, if you use a date clause in combination, it will also get all issues by any user on that date

 

0 votes
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 23, 2024

Hello @Mohan Reddy Kotla 

Welcome to the Atlassian community.

In what way are the "not working"? Are you getting an error message? Are you getting some results but not the results you expect?

None of the "commented..." items you mentioned are either native Jira JQL fields or functions.

https://support.atlassian.com/jira-software-cloud/docs/jql-fields/

https://support.atlassian.com/jira-software-cloud/docs/jql-functions/

In that case I would expect you to get an error message when you try to use them.

The type of filtering you describe would require a third party app. Do you already have such an app available?

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events