title: Querying sharepoint data
body: <p>I have a requirement to retrieve data from share point (I guess it is 2010, but will check with admin if relevant) and generate an excel report/chart. Say we have a bug tracking system in share point. Currently, I could create a view and see some statistics, but I need to plot a graph to see historically (every week) how the number of bugs changed. For example,</p>
  
  <ul>
  <li>get the number of bugs filed in a specific week</li>
  <li>do some grouping based on type/severity</li>
  <li>based on classification get number of bugs solved that week etc.</li>
  </ul>
  
  <p>If I can get the numbers based on date range, I may use excel to plot the graph.</p>
  
  <p>After some reading, SharePoint object model come close to what I used to work with (Oracle DB). I understand it may be entirely different from tradition db and querying.</p>
  
  <p>Please help me with</p>
  
  <ol>
  <li>What is the best method to approach this?</li>
  <li>Is there a good book/resource.</li>
  </ol>
  
  <p>Thanks a lot,<br>
  bsr</p>