I need help in JQL

[Anita Hütter]

We need a filter to have a list with all linked issues:

Something like:

project = "xx" AND issuetype = IR AND status changed TO 'CREATE PR' BY 'user1' AND issueLinkType = clones

The created PRs by user1 should be listed.

Kind regards,

Anita

[arielei · Accepted solution]

Hello  @Anita Hütter 

see here:

project = XXX AND issuetype = XXX AND issueLinkType = XXX AND status Changed To "XXX" BY 'Account Username'

for example:

project = DEMO AND issuetype = Story AND issueLinkType = clones AND status Changed To "In Progress" BY '5f1948face15e800269075b1'

Best Regards,

Ariel

[Jack Brickey]

Oh that is right! You can use accountID. I had forgotten this! Good stuff @arielei 

[Jack Brickey · Accepted solution]

Hi @Anita Hütter , you can't use JQL to find issues specifically transitioned by a specific user. However you can find issues updated by a specific user. So the following would be possible.

project = "xx" AND issuetype = IR AND Issuekey in updatedBy(user1) AND issueLinkType = clones

[Anita Hütter]

We configuered a status "create PR" with an all-transition to create a PR in another project. That is very helpful but to create a list PRs in projects xyz when you created it by this transition it seems to be impossible,