Test HQL

Screen Description

The Test HQL screen is a place to enter an HQL query which uses the timetabling database and see the results of such query.

Details

• Query
  • Enter the HQL query you need
• Result
  • The resulting table

Operations

• Submit
  • Submit the query

Examples

select s from Session s

select t from TimePattern t where t.session.academicTerm='Fal' and t.session.academicYear='2007'

select c from Class_ c inner join c.schedulingSubpart.instrOfferingConfig.instructionalOffering.courseOfferings co
  where co.isControl=true and co.subjectArea.subjectAreaAbbreviation='BIOL'

Notes

• You can find HQL documentation at http://www.hibernate.org/hib_docs/v3/reference/en/html/queryhql.html

• Timetabling hibernate model XML files can be found at https://github.com/UniTime/unitime/tree/master/JavaSource