Dong Shin 01.06.2012

  • deployed the latest PPM and PA
  • reviewed with Tangie
    • She wants to be able to review the budget amounts info for individual sub projects
  • working on viewing budget amount of sub projects
    • query to retrieve yearly budget amounts
    • SELECT c.uid , SUM(amount), year
      FROM budget_centers c
      LEFT JOIN budget_amounts a
      ON c.uid = a.budget_center_id
      WHERE project_id = 99
      GROUP BY year
    • made windows non-modal, can view multiple projects. close all on Create Project panel close