Resistances: Difference between revisions

Resistances (view source)

Revision as of 19:04, 14 December 2021

581 bytes added , 19:04, 14 December 2021

Improved queries with ingredients

Egocarib

Bureaucrats, Interface administrators, Administrators

8,290

edits

@@ Line 47: / Line 47: @@
 === Basic Effects ===
 {{#cargo_query:
-| tables=CookingEffects=CE,CookingEffects__UnitEffects=CEUE
+| tables=CookingEffects=CE,CookingEffects__UnitEffects=CEUE,Liquids__CookEffect=LCE,Liquids=L,Food__CookEffect=FCE,Food=F
-| join on=CE._ID=CEUE._rowID
+| join on=CE._ID=CEUE._rowID,CE.PlainName=LCE._value,LCE._rowID=L._ID,CE.PlainName=FCE._value,FCE._rowID=F._ID
 | fields=
-     CE._pageName=Effect,
+     CONCAT(
-     CEUE._value=Basic Effect
+      '{{(}}favilink id{{!}}',
+      CASE WHEN L.ObjectID IS NOT NULL
+        THEN L.ObjectID
+        ELSE F.ObjectID
+      END,
+      '{{)}}'
+    )=Ingredient,
+     CEUE._value=Cooking Effect,
+    CE._pageName=Effect Category
 | where=CEUE._value LIKE '%Resist%'
-| group by=CE._pageName,CEUE._value
 | format=table
 }}
@@ Line 59: / Line 66: @@
 === Triggered Effects ===
 {{#cargo_query:
-| tables=CookingEffects=CE,CookingEffects__TriggeredEffects=CETE
+| tables=CookingEffects=CE,CookingEffects__TriggeredEffects=CETE,Liquids__CookEffect=LCE,Liquids=L,Food__CookEffect=FCE,Food=F
-| join on=CE._ID=CETE._rowID
+| join on=CE._ID=CETE._rowID,CE.PlainName=LCE._value,LCE._rowID=L._ID,CE.PlainName=FCE._value,FCE._rowID=F._ID
 | fields=
-     CE._pageName=Effect,
+     CONCAT(
-     CETE._value=Triggered Effect
+      '{{(}}favilink id{{!}}',
+      CASE WHEN L.ObjectID IS NOT NULL
+        THEN L.ObjectID
+        ELSE F.ObjectID
+      END,
+      '{{)}}'
+    )=Ingredient,
+     CETE._value=Cooking Effect,
+    CE._pageName=Effect Category
 | where=CETE._value LIKE '%Resist%'
-| group by=CE._pageName,CETE._value
 | format=table
 }}
 [[Category:Mechanics]]