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

[Mohan Reddy Kotla]

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

[Trudy Claspill]

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?

[Dan -minware-]

Disclaimer - marketplace partner.

Hey @Mohan Reddy Kotla - if you are going to be using a marketplace app this is something we can help with at minware. Below is a screenshot from our custom builder - I'm showing commit count to comment count ratio but we can break that down however you'd like using the fields available on the right hand side.

We offer a free trial if you want to check it out - mention this comment and I'm happy to offer an extended trial so you have additional time to explore.

[Marc - Devoteam]

Hi @Mohan Reddy Kotla 

This works fine.

See example: 

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

What is your JQL clause?

[Mohan Reddy Kotla]

@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]

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