Difference between revisions of "CargoTest"
Line 5: | Line 5: | ||
|fields=_pageName=Tournament,Team1=Home,Goals1=Home Goals,Score,Goals2=Away Goals,Team2=Away | |fields=_pageName=Tournament,Team1=Home,Goals1=Home Goals,Score,Goals2=Away Goals,Team2=Away | ||
|format=dynamic table | |format=dynamic table | ||
|where=_pageName LIKE '201% 4Chan%Cup' | |where=_pageName LIKE '201% 4Chan%Cup' | ||
|order by=_PAGEID ASC | |order by=_PAGEID ASC |
Revision as of 04:05, 12 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 |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 }}