Template:GetMaxPrivateEditionReleaseDate - Revision history

Bgrenon: 1 revision imported

2022-05-25T20:29:05Z

1 revision imported

2022-05-25T19:30:42Z

2022-05-19T17:44:55Z

2022-04-20T12:18:07Z

2022-04-11T20:04:52Z

2022-04-11T19:52:10Z

2022-04-11T19:45:35Z

2022-04-11T19:41:59Z

2022-04-11T19:37:40Z

2022-04-11T19:19:45Z

@@ Line 11: / Line 11: @@
 ComponentRN.ComponentId="{{{ComponentId|}}}"
 AND PrivateEditionReleaseDate IS NOT NULL
-AND ComponentRN._pageNamespace="0"
+AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}"
 |format=template
 |template=GetContainers
 |named args=yes
 }}</includeonly><noinclude>[[Category:PrivateEdition]][[Category:ComponentRN.ComponentId cleanup]]</noinclude>

@@ Line 1: / Line 1: @@
 <includeonly><!-- Finding the MAX PrivateEditionReleaseDate and passing that and ComponentId to formatting template -->
 {{#cargo_query:
-tables=ComponentRN,Component
+tables=
-|join on=ComponentRN.ComponentId HOLDS Component.Id
+ComponentRN,
-|fields=ComponentRN.ComponentId=ComponentId,MAX(PrivateEditionReleaseDate)=PrivateEditionReleaseDate
+Component
-|where=ComponentId HOLDS '{{{ComponentId|}}}' AND PrivateEditionReleaseDate IS NOT NULL AND ComponentRN._pageNamespace="0"
+|join on=ComponentRN.ComponentId=Component.Id
 |format=template
 |template=GetContainers
 |named args=yes
-}}</includeonly><noinclude>[[Category:PrivateEdition]]</noinclude>
+}}</includeonly><noinclude>[[Category:PrivateEdition]][[Category:ComponentRN.ComponentId cleanup]]</noinclude>

@@ Line 1: / Line 1: @@
-<!-- Finding the MAX PrivateEditionReleaseDate and passing that and ComponentId to formatting template -->
+<includeonly><!-- Finding the MAX PrivateEditionReleaseDate and passing that and ComponentId to formatting template -->
 {{#cargo_query:
 tables=ComponentRN,Component
@@ Line 8: / Line 8: @@
 |template=GetContainers
 |named args=yes
-}}
+}}</includeonly><noinclude>[[Category:PrivateEdition]]</noinclude>

@@ Line 4: / Line 4: @@
 |join on=ComponentRN.ComponentId HOLDS Component.Id
 |fields=ComponentRN.ComponentId=ComponentId,MAX(PrivateEditionReleaseDate)=PrivateEditionReleaseDate
-|where=ComponentId HOLDS '{{{ComponentId|}}}' AND PrivateEditionReleaseDate IS NOT NULL
+|where=ComponentId HOLDS '{{{ComponentId|}}}' AND PrivateEditionReleaseDate IS NOT NULL AND ComponentRN._pageNamespace="0"
 |format=template
 |template=GetContainers
 |named args=yes
 }}

@@ Line 4: / Line 4: @@
 |join on=ComponentRN.ComponentId HOLDS Component.Id
 |fields=ComponentRN.ComponentId=ComponentId,MAX(PrivateEditionReleaseDate)=PrivateEditionReleaseDate
-|where=ComponentId HOLDS '1bff5e74-a889-4bb8-b75a-8d721f63766e' AND PrivateEditionReleaseDate="2022-04-20"
+|where=ComponentId HOLDS '{{{ComponentId|}}}' AND PrivateEditionReleaseDate IS NOT NULL
-|format=table
+|format=template
 |template=GetContainers
 |named args=yes
 }}

← Older revision	Revision as of 20:29, May 25, 2022
(No difference)