Difference between revisions of "Template:Building query"

Revision as of 15:18, May 19, 2021

New Construction

Error: Table buildings not found.

Renovation

Error: Table buildings not found.

@@ Line 1: / Line 1: @@
-{{#cargo_compound_query:
+New Construction
- tables= buildings; where= architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}'; fields= completion_date=Completed,_pageName=Building,address=Address,image=Image
+{{#cargo_query: table= buildings
- |tables=buildings; where= ren_architect='{{PAGENAME}}';fields=renovation_date=Completed,_pageName=Building,address=Address,image=Image
+|where= architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}'
- |order by=Completed
+|fields= completion_date=Completed,_pageName=Building,address=Address,image=Image
+|order by=completion_date
   |format = table
+}}
+Renovation
+{{#cargo_query: table= buildings
+|where= ren_architect='{{PAGENAME}}' OR architecture_firm='{{PAGENAME}}'
+|fields= renovation_date=Completed,_pageName=Building,address=Address,image=Image
+|order by=renovation_date
+|format = table
 }}