Rovo generates invalid JQL

[KC Wong]

Rovo seems to generate incorrect JQL for month/year. For day it works. 

I asked Rovo:

Find all work items from all spaces created in the last year

Rovo answered: 

Here’s what I can see for “work items from all spaces/projects created in the last year” in your site.

1. Jira work items (all projects, last 12 months)

I ran a site-wide Jira query with:

created >= -12M

But that finds nothing. The proper JQL seems to be this instead: 

created >= startOfMonth("-12") 

[Dr Valeri Colon _Connect Centric_]

Hi @KC Wong Rovo often uses relative date syntax like created >= -12M, which isn’t valid JQL. Jira requires functions such as startOfMonth("-12") or created >= -52w. This isn’t a configuration issue—Rovo doesn’t always generate correct date math for months or years. The workaround is to correct the JQL manually or instruct your agent to use startOfMonth() or startOfYear() when interpreting “last year” queries.

[KC Wong]

That's not an issue for me, but it is for end-users. Rovo will execute the query and tells them 0 issues found. 

I consider that to be in the bug territory...

[Marc -Devoteam-]

Hi @KC Wong 

Created, Updated and Resolved, only work with day (d) parameter.

So you can use "created >= "-365d"

[KC Wong]

I know that, the real problem is Rovo's suggesting to use 12M for 12 months.

[Marc -Devoteam-]

Hi @KC Wong 

Use the Feedback option in the help menu to provide this feedback to Atlassian.