- Weekly status meeting
- deployed new Visiblity and PA – Visibility and AccountManagers didn’t work
- put the old ones back and works!
- compiled new ones on my PC and it works
- looks like we deployed old (really old) version from Maven repo that were packaged together by Visibility server project
- working on overdue projects alerts
- query to get overdue projects in ALERT format
- SELECT GROUP_CONCAT(m.login) as service_project_managers,
GROUP_CONCAT(ppa.login) as porfolio_admins,
GROUP_CONCAT(ppm.login) as portfolio_mgrs,
GROUP_CONCAT(psf.login) as service_finance_pocs,
p.project_number as program,
c.center_number as MIPR,
’30 days overdue’ as alerts,
‘OPEN’ as status,
p.project_number, p.description, a.amount, o.uid, o.type, o.year,
o.year_count, o.month_1
FROM projects p,
budget_centers c,
budget_amounts a,
obligations_outlays o,
_projects_service_project_mgrs m,
_projects_portfolio_admins ppa,
_projects_portfolio_mgrs ppm,
_projects_service_finance_pocs psf
WHERE p.uid = c.project_id
AND a.budget_center_id = c.uid
ANd a.year = 2013 – p.begin_year + 1
AND o.project_id = p.uid
AND o.funding_id = c.uid
AND o.year + o.year_count – 1 = 2013
AND o.year_count = 1
AND ISNULL(o.month_1)
AND p.uid = m.project_id
AND p.uid = ppa.project_id
AND p.uid = ppm.project_id
AND p.uid = psf.project_id
GROUP BY o.uid
viztales 