Difference between revisions of "Template:Building query"

From DAS Wiki
Line 1: Line 1:
====New Construction====
 
 
{{#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=completion_date=Completed,_pageName=Building,address=Address,image=Image
Line 7: Line 6:
 
|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=renovation_date=Completed,_pageName=Building,address=Address,image=Image
 
|order by=completion_date
 
|order by=completion_date
|format = table
 
}}
 
====Renovation====
 
{{#cargo_compound_query:
 
tables= buildings;where=ren_architect='{{PAGENAME}}';fields=renovation_date=Completed,_pageName=Building,address=Address,image=Image
 
|tables= buildings;where=ren_contractors HOLDS'{{PAGENAME}}';fields=renovation_date=Completed,_pageName=Building,address=Address,image=Image
 
|order by=renovation_date
 
 
|format = table
 
|format = table
 
}}
 
}}

Revision as of 09:13, June 16, 2021

Error: Table buildings not found.