Difference between revisions of "User:Mornsta/Sandbox2"

@@ Line 1: / Line 1: @@
-<!--<pre>{{#cargo_query:
-tables=table1=tableAlias1, table2=tablesAlias2, etc.
-|join on=table1.fieldA = table2.fieldB,table2.fieldC=table3.fieldD, etc.
-|fields=field1=fieldAlias1,field2=Alias2, etc.
-|where=table1.fieldE='some value' AND/OR etc.
-|group by=table1.fieldG
-|having=table1.fieldG='some value', etc.
-|order by=table2.fieldF, etc.
-|limit=some number
-|offset=some number
-|intro=some text
-|outro=some text
-|default=some text
-|more results text=some text
-|no html
-|max display chars=some number
-|format=format
-...additional format-based parameters
-}}</pre>-->
-{| class="wikitable sortable" style="text-align:center;"
-! Icon
-! Name
-! Might Value
-! Description
-! Description
-! Description
-! Description
-|-
-{{#invoke:CargoQuery|main
-|q?tables=Abilities
-|q?fields=Id=Id,AbilityIconName=Icon,_pageName=Name,Details=Details,PartyPowerWeight=Might,GenericName,AbilityGroup
-|q?groupBy=_pageName
-|q?orderBy=
-CASE
-WHEN ID IS NULL THEN 0
-WHEN Id < 10 THEN 1
-WHEN Id < 100 THEN 2
-ELSE 0
-END ASC,
-Id ASC
-|q?limit=999
-|template=Test
-}}
-|}

Latest revision as of 02:29, 23 March 2019