Template:ListIpName - Revision history

WikiSysop at 12:30, April 7, 2022

2022-04-07T12:30:30Z

WikiSysop at 12:15, April 7, 2022

2022-04-07T12:15:31Z

WikiSysop at 12:00, April 7, 2022

2022-04-07T12:00:28Z

WikiSysop at 11:45, April 7, 2022

2022-04-07T11:45:29Z

WikiSysop at 11:00, April 7, 2022

2022-04-07T11:00:33Z

WikiSysop at 10:45, April 7, 2022

2022-04-07T10:45:30Z

WikiSysop at 10:30, April 7, 2022

2022-04-07T10:30:31Z

WikiSysop at 10:15, April 7, 2022

2022-04-07T10:15:30Z

WikiSysop at 09:30, April 7, 2022

2022-04-07T09:30:30Z

WikiSysop at 09:15, April 7, 2022

2022-04-07T09:15:30Z

@@ Line 21: / Line 21: @@
 <td>
 {{#cargo_query:
-tables=RNElements,ComponentRN
+tables=ComponentRN,RNElements,Component
-|join on=RNElements.Version=ComponentRN.ReleaseNumber
+|join on=ComponentRN.ReleaseNumber=RNElements.Version,RNElements.IpName=Component.IpName
 |fields=DATE_FORMAT(MAX(PrivateEditionReleaseDate),'%M %d, %Y')
 |format=ul
@@ Line 30: / Line 30: @@
 }}
 {{#cargo_query:
-tables=RNElements,ComponentRN
+tables=ComponentRN,RNElements,Component
-|join on=RNElements.Version=ComponentRN.ReleaseNumber
+|join on=ComponentRN.ReleaseNumber=RNElements.Version,RNElements.IpName=Component.IpName
 |fields=DATE_FORMAT(MAX(MixedModeReleaseDate),'%M %d, %Y')
 |format=ul
@@ Line 43: / Line 43: @@
 <td>
 {{#cargo_query:
-tables=RNElements,ComponentRN
+tables=ComponentRN,RNElements,Component
-|join on=RNElements.Version=ComponentRN.ReleaseNumber
+|join on=ComponentRN.ReleaseNumber=RNElements.Version,RNElements.IpName=Component.IpName
 |fields=RNElements.Filename
 |format=ul
@@ Line 54: / Line 54: @@
 <td>
 {{#cargo_query:
-tables=RNElements,Component
+tables=ComponentRN,RNElements,Component
-|join on=RNElements.IpName=Component.IpName
+|join on=ComponentRN.ReleaseNumber=RNElements.Version,RNElements.IpName=Component.IpName
 |fields=RNElements.Filename
 |format=ul
-|where=Component.Id="{{{ComponentId|}}}" AND RNElements.Version="{{{ReleaseNumber|}}}"  AND Type="docker"
+|where=(ComponentRN.PrivateEditionReleaseDate="{{{ReleaseDate|}}}" OR ComponentRN.MixedModeReleaseDate="{{{MixedReleaseDate|}}}") AND RNElements.IpName="{{{Component|}}}" AND Type="docker"
 |group by=RNElements.Filename
 |default=No updates
 }}
 </td>

@@ Line 15: / Line 15: @@
 |join on=ComponentRN.ReleaseNumber=RNElements.Version,RNElements.IpName=Component.IpName
 |fields=RNElements.Version
-|where=(ComponentRN.PrivateEditionReleaseDate="{{{ReleaseDate|}}}" OR ComponentRN.MixedModeReleaseDate="{{{MixedReleaseDate|}}}") AND RNElements.IpName="{{{Component|}}}"
+|where=(ComponentRN.PrivateEditionReleaseDate="{{{ReleaseDate|}}}" OR ComponentRN.MixedModeReleaseDate="{{{MixedReleaseDate|}}}") AND RNElements.IpName="{{{Component|}}}" AND Component.IpName="{{{Component|}}}"
 |group by=Version
 }}
@@ Line 54: / Line 54: @@
 <td>
 {{#cargo_query:
-tables=RNElements,ComponentRN
+tables=RNElements,Component
-|join on=RNElements.Version=ComponentRN.ReleaseNumber
+|join on=RNElements.IpName=Component.IpName
 |fields=RNElements.Filename
 |format=ul
-|where=(ComponentRN.PrivateEditionReleaseDate="{{{ReleaseDate|}}}" OR ComponentRN.MixedModeReleaseDate="{{{MixedReleaseDate|}}}") AND RNElements.IpName="{{{Component|}}}" AND Type="docker"
+|where=Component.Id="{{{ComponentId|}}}" AND RNElements.Version="{{{ReleaseNumber|}}}"  AND Type="docker"
 |group by=RNElements.Filename
 |default=No updates
 }}
 </td>

@@ Line 15: / Line 15: @@
 |join on=ComponentRN.ReleaseNumber=RNElements.Version,RNElements.IpName=Component.IpName
 |fields=RNElements.Version
-|where=(ComponentRN.PrivateEditionReleaseDate="{{{ReleaseDate|}}}" OR ComponentRN.MixedModeReleaseDate="{{{MixedReleaseDate|}}}") AND RNElements.IpName="{{{Component|}}}"  AND RNElements.Version="{{{Version|}}}"
+|where=(ComponentRN.PrivateEditionReleaseDate="{{{ReleaseDate|}}}" OR ComponentRN.MixedModeReleaseDate="{{{MixedReleaseDate|}}}") AND RNElements.IpName="{{{Component|}}}"
 |group by=Version
 }}
 </td>
 <td>
 {{#if:{{{PEReleaseDateFormat|}}}|P:<br/>{{{PEReleaseDateFormat|}}}}}
 {{#if:{{{MixedReleaseDateFormat|}}}|M:<br/> {{{MixedReleaseDateFormat|}}}}}
@@ Line 40: / Line 58: @@
 |fields=RNElements.Filename
 |format=ul
-|where=(ComponentRN.PrivateEditionReleaseDate="{{{ReleaseDate|}}}" OR ComponentRN.MixedModeReleaseDate="{{{MixedReleaseDate|}}}") AND RNElements.IpName="{{{Component|}}}" AND Type="docker" AND RNElements.Version="{{{Version|}}}"
+|where=(ComponentRN.PrivateEditionReleaseDate="{{{ReleaseDate|}}}" OR ComponentRN.MixedModeReleaseDate="{{{MixedReleaseDate|}}}") AND RNElements.IpName="{{{Component|}}}" AND Type="docker"
 |group by=RNElements.Filename
 |default=No updates
 }}
 </td>

@@ Line 5: / Line 5: @@
 |join on=ComponentRN.ReleaseNumber=RNElements.Version,RNElements.IpName=Component.IpName
 |fields=Component.Name
-|where=ComponentRN.PrivateEditionReleaseDate="{{{ReleaseDate|}}}" AND RNElements.IpName="{{{Component|}}}"
+|where=(ComponentRN.PrivateEditionReleaseDate="{{{ReleaseDate|}}}" OR ComponentRN.MixedModeReleaseDate="{{{MixedReleaseDate|}}}") AND RNElements.IpName="{{{Component|}}}"
 |group by=Component.Name
 }}
 </td>
 <td>
 {{#cargo_query:
 tables=ComponentRN,RNElements,Component
 |join on=ComponentRN.ReleaseNumber=RNElements.Version,RNElements.IpName=Component.IpName
 |fields=RNElements.Version
-|where=(ComponentRN.PrivateEditionReleaseDate="{{{ReleaseDate|}}}" OR ComponentRN.MixedModeReleaseDate="{{{MixedReleaseDate|}}}") AND RNElements.IpName="{{{Component|}}}"
+|where=(ComponentRN.PrivateEditionReleaseDate="{{{ReleaseDate|}}}" OR ComponentRN.MixedModeReleaseDate="{{{MixedReleaseDate|}}}") AND RNElements.IpName="{{{Component|}}}"  AND RNElements.Version="{{{Version|}}}"
-|group by=ReleaseNumber
+|group by=Version
 }}
 </td>
@@ Line 39: / Line 40: @@
 |fields=RNElements.Filename
 |format=ul
-|where=(ComponentRN.PrivateEditionReleaseDate="{{{ReleaseDate|}}}" OR ComponentRN.MixedModeReleaseDate="{{{MixedReleaseDate|}}}") AND RNElements.IpName="{{{Component|}}}" AND Type="docker"
+|where=(ComponentRN.PrivateEditionReleaseDate="{{{ReleaseDate|}}}" OR ComponentRN.MixedModeReleaseDate="{{{MixedReleaseDate|}}}") AND RNElements.IpName="{{{Component|}}}" AND Type="docker" AND RNElements.Version="{{{Version|}}}"
 |group by=RNElements.Filename
 |default=No updates
 }}
 </td>

@@ Line 10: / Line 10: @@
 </td>
 <td>
 {{#cargo_query:
 tables=ComponentRN,RNElements,Component
 |join on=ComponentRN.ReleaseNumber=RNElements.Version,RNElements.IpName=Component.IpName
 |fields=RNElements.Version
-|where=ComponentRN.PrivateEditionReleaseDate="{{{ReleaseDate|}}}" AND RNElements.IpName="{{{Component|}}}"
+|where=(ComponentRN.PrivateEditionReleaseDate="{{{ReleaseDate|}}}" OR ComponentRN.MixedModeReleaseDate="{{{MixedReleaseDate|}}}") AND RNElements.IpName="{{{Component|}}}"
 |group by=ReleaseNumber
 }}
 </td>
 <td>
-{{{ReleaseDateFormat|}}}
+{{#if:{{{PEReleaseDateFormat|}}}|P:<br/>{{{PEReleaseDateFormat|}}}}}
 </td>
 <td>
@@ Line 28: / Line 28: @@
 |fields=RNElements.Filename
 |format=ul
-|where=ComponentRN.PrivateEditionReleaseDate="{{{ReleaseDate|}}}" AND RNElements.IpName="{{{Component|}}}" AND Type="helm"
+|where=(ComponentRN.PrivateEditionReleaseDate="{{{ReleaseDate|}}}" OR ComponentRN.MixedModeReleaseDate="{{{MixedReleaseDate|}}}") AND RNElements.IpName="{{{Component|}}}" AND Type="helm"
 |group by=RNElements.Filename
 |default=No updates
@@ Line 39: / Line 39: @@
 |fields=RNElements.Filename
 |format=ul
-|where=ComponentRN.PrivateEditionReleaseDate="{{{ReleaseDate|}}}" AND RNElements.IpName="{{{Component|}}}" AND Type="docker"
+|where=(ComponentRN.PrivateEditionReleaseDate="{{{ReleaseDate|}}}" OR ComponentRN.MixedModeReleaseDate="{{{MixedReleaseDate|}}}") AND RNElements.IpName="{{{Component|}}}" AND Type="docker"
 |group by=RNElements.Filename
 |default=No updates
 }}
 </td>