Using JQL as field value

[Deleted user]

Hello,

I want to create a custom field that holds the number of issues moved outside a certain project.

I wanted to know if there is a way to do so by using JQL, meaning counting the results of a JQL query and displaying it in the field?

Any other ideas for making this calculation will be useful.

Thank!

[Ziad Bakhiet]

Hello Noga,

You can easily do this with JQL Search Extensions

You can find all issues which are in "Project 1" and moved from project "Project 2".

The JQL will look like this:

project = "Project 1" AND issue in movedIssues("Project 2")

You can find a full documentation here.

Regards,

Ziad

[Derek Fields (RightStar)]

I think that you are looking to create a field associated with a Project? Fields are always associated with an issue. You can't have a field associated with a Project unless you add a plugin. Then, using the plugin, you would need some kind of script to update the field.

[Deleted user]

Hey Derek,

Thanks for the quick response!

I don't mind that the field will be linked to issues, but I do need it to have the same value for all: the total number of issued moved outside the project (I have an appropriate JQL filter).

We do have some plugins (scriptrunner, eazybi etc'), what kind of plugin are you suggesting?