Template:BP ServiceNameVar - Revision history

WikiSysop at 12:31, July 19, 2022

2022-07-19T12:31:08Z

Bgrenon: Undo revision 122294 by Bgrenon (talk)

2022-06-21T15:33:23Z

Undo revision 122294 by Bgrenon (talk)

Bgrenon: switch to HOLDS Component.Id

2022-06-21T15:32:13Z

switch to HOLDS Component.Id

Bgrenon: Component._pageID is fine

2022-06-21T15:06:07Z

Component._pageID is fine

Bgrenon: test removing Component._pageID

2022-06-21T15:05:15Z

test removing Component._pageID

WikiSysop at 20:45, June 14, 2022

2022-06-14T20:45:52Z

WikiSysop at 22:16, June 6, 2022

2022-06-06T22:16:03Z

WikiSysop at 21:16, June 6, 2022

2022-06-06T21:16:13Z

WikiSysop: Created page with "This template is used for displaying the Service (Component) Name.{{#cargo_query:tables=ArticleCloudRN__ComponentId,ArticleCloudRN,Componen..."

2022-03-30T14:40:16Z

Created page with "<noinclude>This template is used for displaying the Service (Component) Name.</noinclude><onlyinclude>{{#cargo_query:tables=ArticleCloudRN__ComponentId,ArticleCloudRN,Componen..."

New page

<noinclude>This template is used for displaying the Service (Component) Name.</noinclude><onlyinclude>{{#cargo_query:tables=ArticleCloudRN__ComponentId,ArticleCloudRN,Component,ComponentRN__ComponentId,ComponentRN|join on=ArticleCloudRN__ComponentId._value=Component.Id, ArticleCloudRN__ComponentId._rowID=ArticleCloudRN._ID, ArticleCloudRN__ComponentId._value = ComponentRN__ComponentId._value, ComponentRN__ComponentId._rowID=ComponentRN._ID|fields=Component.Name|no html|group by=Component.Name|where=ArticleCloudRN._pageName="{{FULLPAGENAME}}" AND ComponentRN.ReleaseNumber = "{{{1}}}"
}}</onlyinclude><noinclude>[[Category:Macros]]</noinclude>

@@ Line 10: / Line 10: @@
 	|join on=
 		ArticleCloudRN.ComponentId HOLDS ComponentRN.ComponentId,
-                ComponentRN.ComponentId=Component.Id
+        ComponentRN.ComponentId=Component.Id
 	|fields=Component.Name
-        |default=<service name>
+    |default=<service name>
 	|no html
 	|group by=Component._pageID,Component.Name
@@ Line 18: / Line 18: @@
 		ArticleCloudRN._pageName="{{FULLPAGENAME}}"
 		AND ComponentRN.ReleaseNumber = "{{{1|}}}"
-                AND ComponentRN.ComponentId = "{{{2|}}}"
+        AND ComponentRN.ComponentId = "{{{2|}}}"
 }}</onlyinclude><noinclude>[[Category:Macros]]</noinclude>

@@ Line 9: / Line 9: @@
 		Component
 	|join on=
-		ArticleCloudRN.ComponentId HOLDS Component.Id,
+		ArticleCloudRN.ComponentId HOLDS ComponentRN.ComponentId,
                  ComponentRN.ComponentId=Component.Id
 	|fields=Component.Name

@@ Line 9: / Line 9: @@
 		Component
 	|join on=
-		ArticleCloudRN.ComponentId HOLDS ComponentRN.ComponentId,
+		ArticleCloudRN.ComponentId HOLDS Component.Id,
                  ComponentRN.ComponentId=Component.Id
 	|fields=Component.Name

@@ Line 14: / Line 14: @@
          |default=<service name>
 	|no html
-	|group by=<!--Component._pageID,-->Component.Name
+	|group by=Component._pageID,Component.Name
 	|where=
 		ArticleCloudRN._pageName="{{FULLPAGENAME}}"

@@ Line 14: / Line 14: @@
          |default=<service name>
 	|no html
-	|group by=Component._pageID,Component.Name
+	|group by=<!--Component._pageID,-->Component.Name
 	|where=
 		ArticleCloudRN._pageName="{{FULLPAGENAME}}"

@@ Line 5: / Line 5: @@
 -->{{#cargo_query:
 	tables=
 		ArticleCloudRN,
-		Component,
+		ComponentRN,
-		ComponentRN__ComponentId,ComponentRN
+		Component
 	|join on=
-		ArticleCloudRN__ComponentId._value=Component.Id,
+		ArticleCloudRN.ComponentId HOLDS ComponentRN.ComponentId,
-		ArticleCloudRN__ComponentId._rowID=ArticleCloudRN._ID,
+                ComponentRN.ComponentId=Component.Id
 	|fields=Component.Name
 	|no html
@@ Line 18: / Line 16: @@
 	|where=
 		ArticleCloudRN._pageName="{{FULLPAGENAME}}"
-		AND ComponentRN.ReleaseNumber = "{{{1}}}"
+		AND ComponentRN.ReleaseNumber = "{{{1|}}}"
 }}</onlyinclude><noinclude>[[Category:Macros]]</noinclude>

← Older revision		Revision as of 21:16, June 6, 2022
Line 1:		Line 1:
−	<noinclude>This template is used for displaying the Service (Component) Name.</noinclude><onlyinclude>{{#cargo_query:tables=ArticleCloudRN__ComponentId,ArticleCloudRN,Component,ComponentRN__ComponentId,ComponentRN\|join on=ArticleCloudRN__ComponentId._value=Component.Id, ArticleCloudRN__ComponentId._rowID=ArticleCloudRN._ID, ArticleCloudRN__ComponentId._value = ComponentRN__ComponentId._value, ComponentRN__ComponentId._rowID=ComponentRN._ID\|fields=Component.Name\|no html\|group by=Component.Name\|where=ArticleCloudRN._pageName="{{FULLPAGENAME}}" AND ComponentRN.ReleaseNumber = "{{{1}}}"	+	<noinclude>This template is used for displaying the Service (Component) Name.</noinclude><onlyinclude><!--
		+
		+	finding name of component
		+
		+	-->{{#cargo_query:
		+	tables=
		+	ArticleCloudRN__ComponentId,
		+	ArticleCloudRN,
		+	Component,
		+	ComponentRN__ComponentId,ComponentRN
		+	\|join on=
		+	ArticleCloudRN__ComponentId._value=Component.Id,
		+	ArticleCloudRN__ComponentId._rowID=ArticleCloudRN._ID,
		+	ArticleCloudRN__ComponentId._value = ComponentRN__ComponentId._value, ComponentRN__ComponentId._rowID=ComponentRN._ID
		+	\|fields=Component.Name
		+	\|no html
		+	\|group by=Component.Name
		+	\|where=
		+	ArticleCloudRN._pageName="{{FULLPAGENAME}}"
		+	AND ComponentRN.ReleaseNumber = "{{{1}}}"
	}}</onlyinclude><noinclude>[[Category:Macros]]</noinclude>		}}</onlyinclude><noinclude>[[Category:Macros]]</noinclude>