Index-Q: Difference between revisions
Created page with "== Veterans — Q == {{#cargo_query: tables=Veterans |fields=_pageName=Name |where=_pageName LIKE "Q%" |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= | |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 "Q%" | |where=UPPER(SUBSTRING_INDEX(_pageName,' ',-1)) LIKE "Q%" | ||
|order by=_pageName | |order by=SUBSTRING_INDEX(_pageName,' ',-1), _pageName | ||
|format= | |format=template | ||
|template=VetRow | |||
|named args=yes | |||
}} | }} | ||