JQL query (Component updations)

[Rahul Aich [Nagra]]

Hi

I want to identify all issues where the component has been updated in the past 1 week.

Is it possible to do it with JQL?

Rahul

[Udo Brand · Accepted solution]

Hi Rahul,

I'm not aware that this is possible with plain JQL. Maybe there are some plugins out there which can do this.

[Rahul Aich [Nagra]]

thanks Udo..

[Udo Brand]

Or you can use SQL:

select newstring,author,g.created,pname from changeitem i ,changegroup g, project p, jiraissue j
where i.groupid=g.id
and j.id = g.issueid
and j.project = p.id
and i.field = 'Component'
and g.created > sysdate -7;