...
Institution, Term have been mandatory for an user to input.
Criteria:
...
Top Level of Query is looking
Query Output Image:
Legend of the Query:
Query SQL:
| Panel |
|---|
SELECT A.EMPLID, C.EMAIL_ADDR FROM PS_STDNT_CAR_TERM A, PS_SCC_EMAIL_QVW C, PS_SCC_EMAIL_QVW D WHERE A.INSTITUTION = :1 AND A.STRM = :2 AND NOT EXISTS (SELECT B.EMPLID FROM PS_STDNT_GRPS_HIST B WHERE B.EFFDT BETWEEN TO_DATE('2015-05-30','YYYY-MM-DD') AND TO_DATE('2015-08-14','YYYY-MM-DD') AND A.EMPLID = B.EMPLID AND A.INSTITUTION = B.INSTITUTION AND B.EFF_STATUS = 'A' AND substr( B.STDNT_GROUP,1,2) IN ('PI')) AND A.UNT_TAKEN_PRGRSS > 0 AND A.EMPLID = C.EMPLID (+) AND 'CAMP' = C.E_ADDR_TYPE (+) AND A.EMPLID = D.EMPLID (+) AND 'OTHR' = D.E_ADDR_TYPE (+) AND ( NOT EXISTS (SELECT E.EMPLID FROM PS_SCC_EMAIL_QVW E WHERE E.EMPLID = A.EMPLID AND E.E_ADDR_TYPE = 'CAMP') OR EXISTS (SELECT F.EMPLID FROM PS_SCC_EMAIL_QVW F WHERE F.EMPLID = A.EMPLID AND F.E_ADDR_TYPE = 'CAMP' AND lower ( F.EMAIL_ADDR) NOT LIKE '%@baruchmail%')) |