Dong Shin 02.22.2011

  • FGMDEV backups working….
  • PPM
    • rearranging components to support Active Project search…
    • Project filtering query…..
      SELECT p.begin_year, (p.end_year+MAX(a.duration)) as end_year, p.uid
      FROM budget_centers c, projects p, appropriations a
      WHERE c.project_id = p.uid AND c.appropriation = a.type
      GROUP BY p.uid

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.