Difference between revisions of "DisplayCharacterMatches"

Revision as of 17:51, 24 September 2021

Template Notes: This is for displaying matches on character pages, using the following text:

{{DisplayCharacterMatches
|LastName=}}

Put the character's last name after the =.

Tournament	Players	Score

@@ Line 12: / Line 12: @@
 |join on=MatchResults.Tournament=Tournaments.TournamentName
 |fields=Tournament,Position,Players1,Players2,Score,Winner,TournamentName,torder
-|where=Players1 REGEXP "{{{LastName|}}}" OR Players2 REGEXP "{{{LastName|}}}"
+|where=Players1 HOLDS LIKE "{{{LastName|}}}" OR Players2 HOLDS LIKE "{{{LastName|}}}"
 |named args=yes
 |format=template
 |template=Match Summary Row 2
-|order by=torder
+|order by=torder,MatchResults._ID
 }}</includeonly>
 </table>