How to get Top committers by LOC and Churns of Code using EyeQL query

Question

I want to get Top committers by LOC and churns of code in Fisheye using EyeQL query. How to form query for both?

Jagadish Nair · Answer

I tried with the following query for a particular author to get LOC:

select revisions from dir "/branches/mybranch" where author=testuser order by date desc return revision,date,author ,path,linesAdded,linesRemoved

I thought sum(linesAdded)-sum(linesRemoved) will give me the LOC of committer 'testuser' in that branch. But the result is not the same with the one mentioned in CodeMetricsReport of Fisheye.

Please let me know what i am doing wrong here.