Template:Collection: Difference between revisions

Revision as of 23:08, 2023 May 12

This template is used at the top of all collection pages to provide consistent listing of their contents.

[Edit template data]
Template parameters
Parameter		Description	Type	Status
description	`description`	What defines this collection. Example This is a collection of information and images about families who live or have lived in Charleswood.	String	required

This template defines the table "Collection". View table.

Collection collection has no pages

@@ Line 24: / Line 24: @@
 </noinclude>__NOEDITSECTION__{{{description| }}}
+{{#cargo_query:
+|tables=CollectedIn, Collection
+|join on=CollectedIn._pageName=Collection._pageName <!-- yes _pN on _pN since we are checking that the pages found are not sub-collections -->
+|fields=CollectedIn._pageName=collected pages
+|where=Collection._pageName is null
+       and (Collection = "{{PAGENAME}}" or Collection WITHIN "{{PAGENAME}}")
+       and not CollectedIn._pageName Like "%.jpg" <!--imgs listed in gallery below-->
+|group by=CollectedIn._pageName
+|limit=1000
+|default={{PAGENAME}} collection has no pages
+|intro===Items in {{PAGENAME}} collection==
+|format=ul
+}}
 {{#cargo_query:
 intro=Sub-collections:
 |format=ul
 |tables=CollectedIn, Collection
-|join on=CollectedIn.Collection=Collection._pageName
+|join on=CollectedIn._pageName=Collection._pageName
 |fields=Collection._pageName
 |where=(Collection = "{{PAGENAME}}" or Collection WITHIN "{{PAGENAME}}") and Collection._pageName>""
+|group by=CollectedIn._pageName
 |limit=1000
 |default=<!-- blank - no sub-collections should be the norm -->
@@ Line 38: / Line 52: @@
 tables=CollectedIn
 |tables=CollectedIn, Collection
-|join on=CollectedIn.Collection=Collection._pageName
+|join on=CollectedIn._pageName=Collection._pageName<!-- yes _pN on _pN since we are checking that the pages found are not sub-collections -->
 |fields=CollectedIn._pageName
 |where=(Collection = "{{PAGENAME}}" or Collection WITHIN "{{PAGENAME}}")