SqlTestTopic

Chair for Computer Aided Medical Procedures & Augmented Reality
Lehrstuhl für Informatikanwendungen in der Medizin & Augmented Reality

All Topics Containing Videos

All Projects supervised by Martin

%SQLMETASEARCH{ 
   SELECT '   * [[', $topic, '][', $FIELD.Title, ']], ', $FIELD.Type, ' by ', $FIELD.Student,'\n' 
   FROM $tables
   WHERE $cond AND $FORM.name='ProjectForm' AND $FIELD.Supervisor LIKE '%MartinBauer%' AND $FIELD.Type='Diploma Thesis' AND NOT $FIELD.Finish=''
   ORDER BY $FIELD.Finish DESC
}%

Last Changed by me

%SQLMETASEARCH{ 
   SELECT '   * [[', $topic, '][', $FIELD.Title, ']]\n' 
   FROM $tables
   WHERE $cond AND $TOPICINFO.author LIKE '%MartinBauer%' 
   ORDER BY $TOPICINFO.date DESC
}%

Lectures by Gudrun

%SQLMETASEARCH{ 
   SELECT '   * [[', $topic, '][', $FIELD.Title, ']], ', $FIELD.Term, '\n' 
   FROM $tables
   WHERE $cond AND $FORM.name='TeachingForm' AND $FIELD.Professor LIKE '%Klinker%' AND $topic LIKE 'Chair.%'
}%

Lectures by Nassir

%SQLMETASEARCH{ 
   SELECT '   * [[', $topic, '][', $FIELD.Title, ']], ', $FIELD.Term, '\n' 
   FROM $tables
   WHERE $cond AND $FORM.name='TeachingForm' AND $FIELD.Professor LIKE '%Nassir%' AND $topic LIKE 'Chair.%'
   ORDER BY $FIELD.Title
}%

Lectures in SS06

%SQLMETASEARCH{ 
   SELECT '   * [[', $topic, '][*', $FIELD.Title, '*]] by ', $FIELD.Professor, ' and ', $FIELD.Tutors, ' (', $FIELD.Information, ')\n'
   FROM $tables
   WHERE $cond AND $FORM.name='TeachingForm' AND $FIELD.Type='Lecture' AND Field.Term='2006SoSe' AND $topic LIKE 'Chair.%'
   ORDER BY $FIELD.Title
}%

All Topics Containing Videos Random Order



Edit | Attach | Refresh | Diffs | More | Revision r1.11 - 08 Dec 2008 - 12:47 - ManuelHuber

Lehrstuhl für Computer Aided Medical Procedures & Augmented Reality    rss.gif