Index-R - Revision history

Donaldson: Raise result limit so letters with >100 veterans are not truncated

2026-07-20T16:55:20Z

Raise result limit so letters with >100 veterans are not truncated

← Older revision		Revision as of 12:55, 20 July 2026
Line 6:		Line 6:
	\|where=UPPER(SUBSTRING_INDEX(_pageName,' ',-1)) LIKE "R%"		\|where=UPPER(SUBSTRING_INDEX(_pageName,' ',-1)) LIKE "R%"
	\|order by=SUBSTRING_INDEX(_pageName,' ',-1), _pageName		\|order by=SUBSTRING_INDEX(_pageName,' ',-1), _pageName
			\|limit=1000
	\|format=template		\|format=template
	\|template=VetRow		\|template=VetRow
	\|named args=yes		\|named args=yes
	}}		}}

Donaldson: List veterans by surname (Last, First), filtered/sorted by last name

2026-07-20T14:38:26Z

List veterans by surname (Last, First), filtered/sorted by last name

← Older revision		Revision as of 10:38, 20 July 2026
Line 3:		Line 3:
	{{#cargo_query:		{{#cargo_query:
	tables=Veterans		tables=Veterans
	\|fields=_pageName=~~Name~~		\|fields=_pageName=Page, SUBSTRING_INDEX(_pageName,' ',-1)=Last, TRIM(SUBSTRING(_pageName,1,CHAR_LENGTH(_pageName)-CHAR_LENGTH(SUBSTRING_INDEX(_pageName,' ',-1))))=First
	\|where=_pageName LIKE "R%"		\|where=UPPER(SUBSTRING_INDEX(_pageName,' ',-1)) LIKE "R%"
	\|order by=_pageName		\|order by=SUBSTRING_INDEX(_pageName,' ',-1), _pageName
	\|format=ul		\|format=template
			\|template=VetRow
			\|named args=yes
	}}		}}

Donaldson: Created page with "== Veterans — R == {{#cargo_query: tables=Veterans |fields=_pageName=Name |where=_pageName LIKE "R%" |order by=_pageName |format=ul }}"

2026-02-19T19:32:21Z

Created page with "== Veterans — R == {{#cargo_query: tables=Veterans |fields=_pageName=Name |where=_pageName LIKE "R%" |order by=_pageName |format=ul }}"

New page

== Veterans — R ==

{{#cargo_query:
tables=Veterans
|fields=_pageName=Name
|where=_pageName LIKE "R%"
|order by=_pageName
|format=ul
}}