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

[zhang zining]

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！

[Renjith Pillai]

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

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

[zhang zining]

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

[zhang zining]

sorry ，should be lines of code