Difference between revisions of "CargoTest"
Line 1: | Line 1: | ||
This is to figure out how the cargo extension works | This is to figure out how the cargo extension works | ||
{{#cargo_query: | |||
tables=CupMatches | |||
|fields=_pageName=Tournament,Team1=Home,Goals1=Home Goals,Score,Goals2=Away Goals,Team2=Away | |||
|format=dynamic table | |||
|merge similar cells = yes | |||
|where=_pageName LIKE '201% 4Chan%Cup' | |||
|order by=_PAGEID ASC | |||
}} | |||
==Official Matches== | ==Official Matches== |
Revision as of 18:23, 4 May 2018
This is to figure out how the cargo extension works
{{#cargo_query: tables=CupMatches |fields=_pageName=Tournament,Team1=Home,Goals1=Home Goals,Score,Goals2=Away Goals,Team2=Away |format=dynamic table |merge similar cells = yes |where=_pageName LIKE '201% 4Chan%Cup' |order by=_PAGEID ASC }}
Official Matches
{{#cargo_query: tables=CupMatches |fields=_pageName=Tournament,Team1=Home,Goals1=Home Goals,Score,Goals2=Away Goals,Team2=Away |format=table |merge similar cells = yes |where=(Team1 LIKE '%mu%' OR Team2 LIKE '%mu%') AND _pageName LIKE '201% 4Chan%Cup' |order by=_PAGEID ASC }}
Unofficial Matches
{{#cargo_query: tables=CupMatches |fields=_pageName,Team1,Goals1,Score,Goals2,Team2 |format=table |where=(Team1 LIKE '%mu%' OR Team2 LIKE '%mu%') AND _pageName NOT LIKE '201% 4Chan%Cup' AND _pageName NOT LIKE 'User%' AND _pageName NOT LIKE '%History%' |order by=_PAGEID ASC }}