Difference between revisions of "User:Eave/Sandbox"

From Dragalia Lost Wiki
Jump to navigation Jump to search
>Eave
m
>Eave
Line 14: Line 14:
  
  
== Event compendium ==
+
== Enemy Parts ==
{{#cargo_query:tables=Events
+
{{#vardefine:PartsAList|{{#cargo_query:tables=EnemiesTest
   |fields=CONCAT('[[', _pageName, '|', Name, ']]')=Name, Date=Date Added
+
  |fields=PartsA
   |where=_pageName LIKE '%Event Compendium%'
+
  |where=Name="Sabnock"
   |format=table
+
  |group by=PartsA
}}
+
  |default=|no html}}}}
 +
{{#vardefine:PartsBList|{{#cargo_query:tables=EnemiesTest
 +
   |fields=PartsB
 +
  |where=Name="Sabnock"
 +
  |group by=PartsB
 +
  |default=|no html}}}}
 +
{{#vardefine:PartsCList|{{#cargo_query:tables=EnemiesTest
 +
  |fields=PartsC
 +
  |where=Name="Sabnock"
 +
  |group by=PartsC
 +
  |default=|no html}}}}
 +
{{#vardefine:PartsDList|{{#cargo_query:tables=EnemiesTest
 +
  |fields=PartsD
 +
  |where=Name="Sabnock"
 +
  |group by=PartsD
 +
  |default=|no html}}}}
 +
{{#cargo_query:tables=EnemiesTest
 +
  |fields=Name
 +
   |where=MonsterId IN ({{#var:PartsAList}},{{#var:PartsBList}},{{#var:PartsCList}},{{#var:PartsDList}})
 +
   |group by=Name
 +
  |default=|no html}}

Revision as of 20:56, 26 April 2020

Boolean {{#if}} proof of concept using IsAffectedByTension

Void Volley (Should be TRUE)

Query result:

Error: Table Skills not found.

IF: TRUE

Abyssal Connection (Should be FALSE)

Query result:

Error: Table Skills not found.

IF: TRUE


Enemy Parts

Error: Table EnemiesTest not found.