Jump to content

Index-C: Difference between revisions

From Iwo Jima Legacy Project
Created page with "== Veterans — C == {{#cargo_query: tables=Veterans |fields=_pageName=Name |where=_pageName LIKE "C%" |order by=_pageName |format=ul }}"
 
Raise result limit so letters with >100 veterans are not truncated
 
(One intermediate revision by the same user not shown)
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 "C%"
|where=UPPER(SUBSTRING_INDEX(_pageName,' ',-1)) LIKE "C%"
|order by=_pageName
|order by=SUBSTRING_INDEX(_pageName,' ',-1), _pageName
|format=ul
|limit=1000
|format=template
|template=VetRow
|named args=yes
}}
}}

Latest revision as of 12:51, 20 July 2026

Veterans — C

[edit]