Test HQL
Screen Description
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
Details
Query
Enter the HQL query you need
Result
The resulting table
Operations
Operations
Submit
Submit the query
Notes
Notes
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=1 and co.subjectArea.subjectAreaAbbreviation='BIOL'
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 http://unitime.cvs.sourceforge.net/unitime/UniTime/JavaSource
