Difference between revisions of "Template: GetMaxPrivateEditionReleaseDate"
From Genesys Documentation
m (1 revision imported) |
|||
| (10 intermediate revisions by 4 users not shown) | |||
| 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: | {{#cargo_query: | ||
| − | tables=ComponentRN,Component | + | tables= |
| − | |join on=ComponentRN.ComponentId | + | ComponentRN, |
| − | |fields=ComponentRN.ComponentId=ComponentId,MAX(PrivateEditionReleaseDate)=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 | |format=template | ||
|template=GetContainers | |template=GetContainers | ||
|named args=yes | |named args=yes | ||
| − | }} | + | }}</includeonly><noinclude>[[Category:PrivateEdition]][[Category:ComponentRN.ComponentId cleanup]]</noinclude> |