how to count the number of lines of code for each review

Question

I want to count the number of lines of code for each review ，How do I count，which table of crucible i could get？

I can find the author reviewer  and some other info，but i cant find the number of lines of code for each review ！

thanks  alot！

zhang zining · Answer

sorry ，should be lines of code

zhang zining · Answer

thanks，but i want to count the munber by sql ！i want to kown the count number of code in which table？

Renjith Pillai · Answer

Use REST, dump it into a csv and do the calculation

https://code.google.com/p/crucible-excel-dump/wiki/InstallationAndUsage