Dong Shin 06.12.2014

  • working on Query Builder
    • converted old queries to new format
    • reworked __view_total_committed_amount_by_budget_center
      • CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `__view_total_committed_amount_by_budget_center` AS select `committed_amounts`.`budget_center_id` AS `budget_center_id`,sum(`committed_amounts`.`committed_amount`) AS `total_committed_amount`,MAX(`committed_amounts`.`committed_date`) AS `max_committed_date`, group_concat(`committed_amounts`.`committed_date` separator ‘,’) AS `committed_dates` from `committed_amounts` group by `committed_amounts`.`budget_center_id`;
    • reworked __view_project_detailed_data to include obligation date and committed date
    • going through the user queries….
  • svn migration complete – trying to check out…
Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: