- continue working on Project Totals display
- insert/update queries..
- save / update / retrieve working
- added filtering for Sub Project selection window
- filter on Project ID and Project Name
- adjusted sub project selection queries to find the start and end year that falls within the parent
- SELECT uid, project_number as projectID, title as projectName, begin_year as startFY,
end_year as endFY, total_budget as totalBudget, 0 as isSelected
FROM projects
WHERE uid NOT IN (SELECT project_id FROM _project_sub_projects)
AND uid NOT IN (SELECT sub_project_id FROM _project_sub_projects)
AND begin_year >= (SELECT begin_year FROM projects WHERE uid = 102)
AND end_year <= (SELECT end_year FROM projects WHERE uid = 102)
AND uid <> 102
- SELECT uid, project_number as projectID, title as projectName, begin_year as startFY,
- helped Phil building PPM
- need to change Flex Project settings…