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=_pageName=Project,completion_date=Completed,address=Address,image=Image
+
tables=buildings;where=architect='{{PAGENAME}}' OR landscape_architect='{{PAGENAME}}';fields=_pageName=Project,completion_date=Completed,address=Address,image=Image
 
|tables=buildings;where=architecture_firm='{{PAGENAME}}';fields=_pageName=Project,completion_date=Completed,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=_pageName=Project,completion_date=Completed,address=Address,image=Image
 
|tables=buildings;where=contractors HOLDS '{{PAGENAME}}';fields=_pageName=Project,completion_date=Completed,address=Address,image=Image
|tables= buildings;where=ren_architect='{{PAGENAME}}';fields=_pageName=Project,renovation_date=Completed,address=Address,image=Image
+
|tables= buildings;where=ren_architect='{{PAGENAME}}'OR ren_l_a='{{PAGENAME}}';fields=_pageName=Project,renovation_date=Completed,address=Address,image=Image
 
|tables=buildings;where=ren_contractors HOLDS'{{PAGENAME}}';fields=_pageName=Project,renovation_date=Completed,address=Address,image=Image
 
|tables=buildings;where=ren_contractors HOLDS'{{PAGENAME}}';fields=_pageName=Project,renovation_date=Completed,address=Address,image=Image
 
|order by=_pageName ASC
 
|order by=_pageName ASC
 
|format=dynamic table
 
|format=dynamic table
 
}}
 
}}

Revision as of 10:00, June 16, 2021

Projects

Error: Table buildings not found.