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