Query on EyeQL

Question

Hello,

I need help on writing a query for getting the number of Lines of code changed in a given branch (changed, added or deleted) between 2 dates (or tags)

Rajeev dave1 · Answer

I guess I need to explain "between 2 dates" a bit better.

Within the date boundaries given, I can potentially add some lines of code and subsequently delete them. Impact of changes like this should not be reflected in the LoC calculation

Sergey Svishchev · Answer

select revisions where 
(on branch fileutil and date in [2012-07-19T22:00:00.00Z, 2012-08-01T21:59:59.00Z]) 
order by date desc
return sum(linesAdded), sum(linesRemoved)

(Number of changed lines is not tracked separately.)