Difference between revisions of "Template: GetMaxPrivateEditionReleaseDate"
From Genesys Documentation
m (1 revision imported) |
|||
| (22 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| + | <includeonly><!-- Finding the MAX PrivateEditionReleaseDate and passing that and ComponentId to formatting template --> | ||
{{#cargo_query: | {{#cargo_query: | ||
| − | tables=ComponentRN,Component | + | tables= |
| − | |join on=ComponentRN.ComponentId | + | ComponentRN, |
| − | |fields=MAX(PrivateEditionReleaseDate) | + | Component |
| − | |where=ComponentId | + | |join on=ComponentRN.ComponentId=Component.Id |
| − | }} | + | |fields= |
| + | ComponentRN.ComponentId=ComponentId, | ||
| + | MAX(PrivateEditionReleaseDate)=PrivateEditionReleaseDate | ||
| + | |where= | ||
| + | ComponentRN.ComponentId="{{{ComponentId|}}}" | ||
| + | AND PrivateEditionReleaseDate IS NOT NULL | ||
| + | AND ComponentRN._pageNamespace="{{NAMESPACENUMBER}}" | ||
| + | |format=template | ||
| + | |template=GetContainers | ||
| + | |named args=yes | ||
| + | }}</includeonly><noinclude>[[Category:PrivateEdition]][[Category:ComponentRN.ComponentId cleanup]]</noinclude> | ||