AnsweredAssumed Answered

Table Project : is_template

Question asked by cris.perezcoll on May 18, 2011
Latest reply on May 18, 2011 by Dave
Hi,
I need make a select for search a project. I have this:

SELECT DISTINCT T.PRID, T.PREXTERNALID, T.PRNAME , T.PRPROJECTID, I.CODE, I.NAME, T.PRFINISH, R.EMAIL AS EMAIL
FROM CLARITY.PRTASK T, CLARITY.PRASSIGNMENT A, CLARITY.INV_INVESTMENTS I, CLARITY.SRM_RESOURCES R, CLARITY.ODF_CA_PROJECT P
WHERE I.ID = T.PRPROJECTID AND T.PRID = A.PRTASKID AND R.ID = A.PRRESOURCEID AND T.PRISKEY = 1 AND P.ID = T.PRPROJECTID AND P.SM_TIPOPROYECTO = 3 AND (T.PRSTATUS != 2 OR T.PRPCTCOMPLETE != 1)

AND T.PRFINISH < (sysdate -1)
UNION
SELECT T.PRID, T.PREXTERNALID, T.PRNAME , T.PRPROJECTID, I.CODE, I.NAME, T.PRFINISH, U.EMAIL_ADDRESS AS EMAIL
FROM CLARITY.PRTASK T, CLARITY.PRASSIGNMENT A, CLARITY.INV_INVESTMENTS I, CLARITY.CMN_SEC_USERS U, CLARITY.ODF_CA_PROJECT P
WHERE I.ID = T.PRPROJECTID AND T.PRID = A.PRTASKID AND U.ID = I.MANAGER_ID AND T.PRISKEY = 1 AND P.ID = T.PRPROJECTID AND P.SM_TIPOPROYECTO = 3 AND
P.ID = I.ID AND (T.PRSTATUS != 2 OR T.PRPCTCOMPLETE != 1) AND T.PRFINISH < (sysdate - 1)
ORDER BY EMAIL

I need the table who have the field is_template because i don't want tamplates projects.
¿What is?
Thanks a lot.

Outcomes