AnsweredAssumed Answered

Operators and Conditions with ESS Reporting

Question asked by edwilson on Mar 24, 2017
Latest reply on Mar 24, 2017 by beverly

Is it possible to include operators or conditions such as "Like" and "In" to develop a real-time ESS report? I am trying to develop a real-time report from an external Oracle database based on the below SQL query, but I am unaware of how to generate an ESS report based on specific criteria. Thank you.

 

-------------------------

 

Select y.LAST_NAME "LAST NAME", y.FIRST_NAME "FIRST NAME", y.DESCR_LABEL "COURSE", y.LETTER_GRADE_FIN "FINAL GRADE", V.DESCR "HIGH STAKES TYPE", z.descr "HIGH STAKES DESCRIPTION", x.NUMERIC_GRADE "NUMERIC ELEMENT"

from OUWB_PROD.sr_enroll_el_grade x, OUWB_PROD.SR_V_ENROLL y, OUWB_PROD.sr_crsect_grade_el z, OUWB_Prod.SR_STUDENT w, OUWB_Prod.SR_GRADE_EL_TYPE v

where x.ENRL_ID = y.ENRL_ID

and x.CSGREL_ID = z.CSGREL_ID

and y.NAME_ID = w.NAME_ID

and z.GETY_ID = v.GETY_ID

and v.GETY_ID in ('MID', 'FIN', 'RETE', 'LABP') --Final Exam, Midterm Exam, Lab Practical, Retest

and z.descr not like ('%Prelim%')

and w.WDRW_REASON_CODE is null

group by y.LAST_NAME, y.FIRST_NAME, y.DESCR_LABEL, y.LETTER_GRADE_FIN, V.DESCR, z.descr, x.NUMERIC_GRADE

order by LAST_NAME, DESCR_LABEL;

Outcomes