Skip to main content



query
RESULTSET
query
  GRAD_YEAR NUMBER_OF_ITEMS
1 2013 4
2 2012 8
CACHED false
EXECUTIONTIME 115
SQL SELECT grad_year , COUNT(grad_id) AS number_of_items FROM iwsGRAD_grads WHERE grad_active = 1 AND grad_archived = 1 AND dept_id = ? GROUP BY grad_year ORDER BY grad_year DESC
SQLPARAMETERS
array
1 4.0
query
RESULTSET
query
  DEPT_ABBR DEPT_ID DEPT_TITLE GRAD_ACTIVE GRAD_ARCHIVED GRAD_BIO GRAD_COMPANY GRAD_CREATED GRAD_CV_FILENAME GRAD_DEGREE GRAD_EMAIL GRAD_FEATURED GRAD_FIELD GRAD_FIELD_OTHER GRAD_FIRST_NAME GRAD_ID GRAD_IMAGE_FILENAME GRAD_JOBTITLE GRAD_LAST_NAME GRAD_LOCATION GRAD_MODIFIED GRAD_PERSONAL_PROFILE_URL GRAD_PHONE GRAD_PROFILE_URL GRAD_RESEARCH_GROUP GRAD_SEMESTER GRAD_SHORT_BIO GRAD_THUMB_FILENAME GRAD_YEAR R
CACHED false
EXECUTIONTIME 3
SQL SELECT f.* , d.dept_title , d.dept_abbr , ROW_NUMBER() OVER (ORDER BY UPPER(grad_last_name) ASC ) R FROM iwsGRAD_grads f LEFT OUTER JOIN iwsdept_departments d ON f.dept_id = d.dept_id WHERE 1=1 AND f.grad_active = 1 AND (f.grad_year >= 2014 or f.grad_year IS NULL) AND f.grad_archived = 0 AND f.dept_id IN (?) ORDER BY UPPER(grad_last_name) ASC
SQLPARAMETERS
array
1 4

Copy of Graduate Students

  • All
  • A
  • B
  • C
  • D
  • E
  • F
  • G
  • H
  • I
  • J
  • K
  • L
  • M
  • N
  • O
  • P
  • Q
  • R
  • S
  • T
  • U
  • V
  • W
  • X
  • Y
  • Z

See previous years

No results.