Difference between revisions of "Template:Building query"

From DAS Wiki
Line 1: Line 1:
 
====Projects====
 
====Projects====
 
{{#cargo_compound_query:
 
{{#cargo_compound_query:
tables=buildings;where=architect='{{PAGENAME}}';fields=completion_date=Completed,_pageName=Building,address=Address,image=Image
+
tables=buildings;where=architect='{{PAGENAME}}';fields=_pageName=Project,completion_date=Completed,address=Address,image=Image
|tables=buildings;where=architecture_firm='{{PAGENAME}}';fields=completion_date=Completed,_pageName=Building,address=Address,image=Image
+
|tables=buildings;where=architecture_firm='{{PAGENAME}}';fields=_pageName=Project,completion_date=Completed,address=Address,image=Image
|tables=buildings;where=contractors HOLDS '{{PAGENAME}}';fields=completion_date=Completed,_pageName=Building,address=Address,image=Image
+
|tables=buildings;where=contractors HOLDS '{{PAGENAME}}';fields=completion_date=Completed,address=Address,image=Image
|tables= buildings;where=ren_architect='{{PAGENAME}}';fields=renovation_date=Completed,_pageName=Building,address=Address,image=Image
+
|tables= buildings;where=ren_architect='{{PAGENAME}}';fields=_pageName=Project,renovation_date=Completed,address=Address,image=Image
|tables= buildings;where=ren_contractors HOLDS'{{PAGENAME}}';fields=renovation_date=Completed,_pageName=Building,address=Address,image=Image
+
|tables= buildings;where=ren_contractors HOLDS'{{PAGENAME}}';fields=_pageName=Project,renovation_date=Completed,address=Address,image=Image
|order by=completion_date
+
|order by=-pageName
 
|format = table
 
|format = table
 
}}
 
}}

Revision as of 09:18, June 16, 2021

Projects

Error: Table buildings not found.