pathCast
Log in

Difference between revisions of "Template:pathCast"

From pathCast
Line 2: Line 2:
 
_table = pathCast
 
_table = pathCast
 
|date = Date
 
|date = Date
|presenter = String (size=255)
+
|presenter1 = String (size=255)
|presenteralt = String (size=255)
+
|presenter2 = String (size=255)
 +
|presenter3 = String (size=255)
 
|title = String (size=255)
 
|title = String (size=255)
 
|subspecialty = String (size=255)
 
|subspecialty = String (size=255)
Line 17: Line 18:
 
_table = pathCast
 
_table = pathCast
 
|date = {{{date|2020/04/11}}}
 
|date = {{{date|2020/04/11}}}
|presenter = {{{presenter|}}}
+
|presenter1 = {{{presenter|}}}
|presenteralt = {{{presenteralt|null}}}
+
|presenter2 = {{{presenter|null}}}
 +
|presenter3 = {{{presenter|null}}}
 
|title = {{{title|}}}
 
|title = {{{title|}}}
 
|subspecialty = {{{subspecialty|}}}
 
|subspecialty = {{{subspecialty|}}}
Line 31: Line 33:
 
}}__NOCACHE__{{#cargo_query:
 
}}__NOCACHE__{{#cargo_query:
 
tables=pathCast,faculty,subspecialty
 
tables=pathCast,faculty,subspecialty
|join on=pathCast.presenter=faculty.namefirstlast,pathCast.subspecialty=subspecialty.subspecialty
+
|join on=pathCast.presenter1=faculty.namefirstlast,pathCast.subspecialty=subspecialty.subspecialty
 
|fields=
 
|fields=
 
,pathCast.title
 
,pathCast.title
Line 44: Line 46:
 
,faculty.institution
 
,faculty.institution
 
,pathCast.subspecialty
 
,pathCast.subspecialty
,pathCast.presenter
+
,pathCast.presenter1
 
,subspecialty._pageName
 
,subspecialty._pageName
 
,faculty._pageTitle
 
,faculty._pageTitle
,pathCast.presenteralt
+
,pathCast.presenter2
 +
,pathCast.presenter3
 
|where=pathCast._pageName='{{FULLPAGENAME}}'
 
|where=pathCast._pageName='{{FULLPAGENAME}}'
 
|format=template|template=pathCastPage|}}
 
|format=template|template=pathCastPage|}}

Revision as of 15:06, 6 September 2020

Template:CTRADMINThis template defines the table "pathCast". View table. [1]