A-Z Index: Difference between revisions
Created page with "== Iwo Jima Veterans Index == {{#cargo_query: tables=Veterans |fields=CONCAT('', SUBSTRING(name,1,1), '')=Letter, COUNT(*)=Count |group by=SUBSTRING(name,1,1) |order by=SUBSTRING(name,1,1) |format=ul }}" |
Group index by surname initial instead of first name |
||
| (13 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Veterans | tables=Veterans | ||
|fields= | |fields=UPPER(SUBSTRING(SUBSTRING_INDEX(_pageName,' ',-1),1,1))=Letter, COUNT(_pageName)=Count | ||
| | |where=UPPER(SUBSTRING(SUBSTRING_INDEX(_pageName,' ',-1),1,1)) BETWEEN "A" AND "Z" | ||
|order by= | |group by=Letter | ||
|format= | |order by=Letter | ||
|format=template | |||
|template=AZRow | |||
|named args=yes | |||
}} | }} | ||