Count Number of FixVersion

[Carl-Marcus Scheffler]

Hi,
I would like to count by the number of FixVersion certain Stories have.

For example I have a project Foo and want to see how many FixVersions a Story in the current Sprint has. According to the howTos this should work something like this:

project = FOO and Sprint in openSprints() AND issueFunction in aggregateExpression("Count of FixVersions","fixVersion.count()")

But this does not work. Any ideas? 

[fjodors]

Hi

Looks like "FixVersion" type is not suitable for count function.

issueFunction in aggregateExpression("count FixVersion/s") returns error "Field s not found or not a Number, Date, or Duration custom field.",

so I assume it will not work for any other types.

I think you can write scriptrunner code, that returns issues from specified JQL and then you can handle FixVersions per each issue.

Try something like this:

def jqlS = "<your JQL>";
def query = jqlQueryParser.parseQuery(jqlS);
def resultIssues = searchProvider.search(query, user, PagerFilter.getUnlimitedFilter())
def issList=resultIssues.getIssues();

if(issList.size()!=0){
/*review each issue*/
issList.each{iss ->
Collection<Version> issVerCol = iss.getFixVersions();
/*do something with versions*/
...

}
}