Template: TeacherClasses: Difference between revisions

Revision as of 14:00, 4 February 2025

This is the 'TeacherClasses' template. It pulls from the table Classes and filters by pagename for teacher, using Template:ClassDisplay to format. Because "Classes.Teacher" is not an included field, it is not displayed. It should be called in the following format:

{{TeacherClasses}}

Which yields the following for teacher Kelly Foshee:

Error: No field named "prerequisites" found for the database table "Classes".

Capstones

No results

@@ Line 8: / Line 8: @@
 {{#tweekihide: sidebar-right}}{{#cargo_query:
 tables=Classes
-|fields=Classes.Name, Classes.description, Classes.Requiredby, Classes.Sessions, Classes.Opento
+|fields=Classes.Name, Classes.description, Classes.Requiredby, Classes.Sessions, Classes.Opento, Classes.prerequisites
 |where=Classes.Teacher HOLDS "Kelly Foshee" AND Classes.Offered="Currently"
 |order by=Classes.Name ASC
@@ Line 30: / Line 30: @@
 {{#cargo_query:
 tables=Classes
-|fields=Classes.Name, Classes.description, Classes.Requiredby, Classes.Sessions
+|fields=Classes.Name, Classes.description, Classes.Requiredby, Classes.Sessions, Classes.Opento, Classes.prerequisites
 |where=Classes.Teacher HOLDS "{{PAGENAME}}" AND Classes.Offered="Currently"
 |format=template
@@ Line 43: / Line 43: @@
 {{#cargo_query:
 tables=Classes
-|fields=Classes.Name, Classes.description, Classes.Requiredby, Classes.Sessions
+|fields=Classes.Name, Classes.description, Classes.Requiredby, Classes.Sessions, Classes.Opento, Classes.prerequisites
 |where=Classes.Teacher HOLDS "{{PAGENAME}}" AND Classes.Offered!="Currently"
 |format=template