Sorting pages with numerical names last

[a-ok]

Is it possible, when sorting pages by 'name' to place any numerical 'names' to the bottom, rather than at the top (first)?

[FrancisChung]

You'll probably have to create a pseudo name sort field and populate that pseudo name field with the desired sort values and sort by that field ....

[horst]

sorting descendend, and not ascendend?

[fbg13]

@oma

I assume you want them ordered ascending and the ones starting with a number at the end.

You could do this by storing the numerical names in a variable and echoing that variable after the "normal" names.

$numericalNames = "";
$normalNames = "";
$names = $pages->find("template=template_name");
foreach($names as $n)
{
	/* get the first letter of the current name */
	$firstLetter = substr($n->name, 0, 1);
	$regexPattern = "/[0-9]/";
	// if first letter is a number
	if(preg_match($regexPattern, $firstLetter))
	{
		$numericalNames .= $n->name;
	}
	else
	{
		$normalNames .= $n->name;
	}
}
echo $normalNames;
echo $numericalNames;

 

[BitPoet]

If you only want to sort in-memory, getting the pages as a plain array and using a custom sort function should do the trick:

<?php

$ps = $pages->find('yourselector')->getArray();

usort($ps, function($a, $b) {
	$na = $a->name;
	$nb = $b->name;
	if(!ctype_digit($na) && !ctype_digit($nb)) return strcmp($na, $nb);
	if(ctype_digit($na) && ctype_digit($nb)) return strcmp($na, $nb);
	
	return (ctype_digit($na)) ? 1 : -1;
});

foreach($ps as $p) echo $p->name . PHP_EOL;

 

[a-ok]

Thanks, folks! Has anyone else had this 'issue', or is it generally common practice to have numbers first, rather than last? I wonder if it would be possible to suggest an PW API avaliable for an option like this?

[szabesz]

1 hour ago, oma said:

generally common practice to have numbers first,

I think the answer to it is yes:

https://en.wikipedia.org/wiki/ASCII#Character_order

Historically, numbers are listed first in dictionaries (real books) as well, at least in Hungarian books  

Edited October 31, 2016 by szabesz
typo