Jump to content

Index-D: Difference between revisions

From Iwo Jima Legacy Project
Created page with "== Veterans — D == {{#cargo_query: tables=Veterans |fields=_pageName=Name |where=_pageName LIKE "D%" |order by=_pageName |format=ul }}"
 
List veterans by surname (Last, First), filtered/sorted by last name
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 "D%"
|where=UPPER(SUBSTRING_INDEX(_pageName,' ',-1)) LIKE "D%"
|order by=_pageName
|order by=SUBSTRING_INDEX(_pageName,' ',-1), _pageName
|format=ul
|format=template
|template=VetRow
|named args=yes
}}
}}

Revision as of 10:37, 20 July 2026

Veterans — D