Difference between revisions of "CargoTest"

From Rigged Wiki
Jump to navigation Jump to search
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
|merge similar cells = yes
|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 }}