Template: TeacherClasses: Difference between revisions

From TSAS Library
Jump to: navigation, search
No edit summary
No edit summary
Line 9: Line 9:
tables=Classes
tables=Classes
|fields=Classes.Name, Classes.description, Classes.Requiredby
|fields=Classes.Name, Classes.description, Classes.Requiredby
|where=Classes.Teacher="Ademola Adeyemi"
|where=Classes.Teacher="Ademola Adeyemi" AND Classes.Offered="Currently"
|order by=Classes.Name ASC
|order by=Classes.Name ASC
|format=template
|format=template
Line 23: Line 23:
tables=Classes
tables=Classes
|fields=Classes.Name, Classes.description, Classes.Requiredby
|fields=Classes.Name, Classes.description, Classes.Requiredby
|where=Classes.Teacher="{{PAGENAME}}"
|where=Classes.Teacher="{{PAGENAME}}" AND Classes.Offered="Currently"
|order by=Classes.Name ASC
|order by=Classes.Name ASC
|format=template
|format=template

Revision as of 22:26, 14 January 2022

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 Ademola Adeyemi:

Error: operator for the virtual field 'Classes.Teacher' must be 'HOLDS', 'HOLDS NOT', 'HOLDS LIKE' or 'HOLDS NOT LIKE'.

Capstones

No results