Clearview InFocus/Unanet project import queries

Below are sample queries that can be used when creating a SQL import from Clearview InFocus:

Project level:

SELECT Projects.ProjectCode AS ProjectNumber, Projects.ProjectName AS ProjectName,
ProjectFacts.IsActive AS Status
FROM Projects, ProjectFacts
WHERE Projects.FactID=ProjectFacts.FactID
AND ProjectLevel = '1'
AND IsActive = '1'

Phase level:

SELECT b.ProjectCode AS ParentProject,
a.ProjectCode AS PhaseNumber,
a.ProjectName AS PhaseName
FROM Projects a
INNER JOIN ProjectFacts c
ON a.FactID=c.FactID
INNER JOIN
(SELECT Projects.ProjectID, Projects.ProjectCode
FROM Projects, ProjectFacts
WHERE Projects.FactID=ProjectFacts.FactID
AND ProjectLevel = '1'
AND IsActive = '1') b
ON a.ParentProjectID=b.ProjectID
WHERE a.ProjectLevel = '2'
AND c.IsActive = '1'