pathCast
Log in

Difference between revisions of "pathCast"

From pathCast
Line 6: Line 6:
 
|join on=pathCast.presenter1=faculty.namefirstlast,pathCast.subspecialty=subspecialty.subspecialty
 
|join on=pathCast.presenter1=faculty.namefirstlast,pathCast.subspecialty=subspecialty.subspecialty
 
|fields=
 
|fields=
,CONCAT('{{tabledate{{#urldecode:%7C}}',pathCast.date,'}}')=Date
+
,pathCast._pageName
,CONCAT('[[',faculty._pageName,'|',pathCast.presenter1,']], ',faculty.degree)=Presenter
+
,pathCast.title
,faculty.institution=Institution
+
,pathCast.urlyt
,CONCAT('{{tablelink{{#urldecode:%7C}}',pathCast._pageName,'{{#urldecode:%7C}}',pathCast.title,'{{#urldecode:%7C}}',pathCast.urlyt,'}}')=Lecture
 
,CONCAT('[[',subspecialty._pageName,'|',subspecialty.name,']]')=Subspecialty
 
 
|where=DATEDIFF(pathCast.date,NOW()) >= -0 AND hide=0
 
|where=DATEDIFF(pathCast.date,NOW()) >= -0 AND hide=0
 
|order by=pathCast.date ASC
 
|order by=pathCast.date ASC

Revision as of 10:49, 7 September 2020



pathCast

No results