sorting pages with exception

[ngrmm]

i'd like to have a list of pages sorted by „creation“.

$articles = $pages->find("template=x|y, sort=creation");

 

all the pages have a checkbox-field. the name of the checkbox-field is highlight.

and it is a autojoin-field.

i want all the highlight-pages listed above the others

i don't know how to handle checked and not checked as a value

this doesn't work

$articles = $pages->find("template=x|y, sort=highlight,  sort=creation" );

[ngrmm]

i solved it this was:

$articles = $pages->find("template=photo|video, highlight=1, sort=created, ");

$articles_2 = $pages->find("template=photo|video, highlight=0, sort=created, ");

…

 

but it seems there could be a better way with less code

[Jan Romero]

Hi ngrmm,

the value of a checkbox is 0 for unchecked and 1 for checked, so to have checked pages at the top, you have to sort in descending order. Simply prepend a - to the field:

$articles = $pages->find('template=x|y, sort=-highlight, sort=creation');