Sort by checkbox status

[suntrop]

Hi all! I want to sort child-pages by two fields but I don't know if it is possible within one selector or if I have to make two separate queries

<?php foreach ($page->children('sort=checkbox, sort=-number') as $child): ?>

I want to keep 'checked' pages on top and sort them and all following by the 'number' field. The 'checkbox' field is a 

[szabesz]

Hi, Can you give us an example? I cannot seem to follow... Also, your post seems to be cut off at:

  On 10/23/2017 at 1:41 PM, suntrop said:

The 'checkbox' field is a 

Expand  

 

[suntrop]

Nobody loves my riddles  

It should read … "The 'checkbox' field is a default checkbox field, no special module"

<?php foreach ($page->children('sort=-chiffre') as $child): ?>
	<div class="job <?= $child->highlight ? 'hightlight' : 'default' ?>">Chiffre <?= $child->chiffre ?> | <?= $child-title ?> – <?= $child->body ?></div>
<?php endofreach ?>

… will render …

<div class="jobs">
	<div class="job">Chiffre 734 | Job Title – Job Description …</div>
	<div class="job">Chiffre 732 | Job Title – Job Description …</div>
	<div class="job highlight">Chiffre 722 | Job Title – Job Description …</div>
	<div class="job">Chiffre 720 | Job Title – Job Description …</div>
	<div class="job">Chiffre 718 | Job Title – Job Description …</div>
	<div class="job highlight">Chiffre 605 | Job Title – Job Description …</div>
</div>

But what I need …

<div class="jobs">
	<div class="job highlight">Chiffre 605 | Job Title – Job Description …</div>
	<div class="job highlight">Chiffre 722 | Job Title – Job Description …</div>
	<div class="job">Chiffre 734 | Job Title – Job Description …</div>
	<div class="job">Chiffre 732 | Job Title – Job Description …</div>
	<div class="job">Chiffre 720 | Job Title – Job Description …</div>
	<div class="job">Chiffre 718 | Job Title – Job Description …</div>
</div>

… the pages with a checked "highlight" (the checkbox field) should be on top and ordered by the chiffre. The other pages should follow and ordered by chiffre too.

[maxf5]

From the docs:

 

  Quote

You may specify multiple fields to sort by. For example, lets say that you wanted to sort first by date descending (newest to oldest) and then by title ascending, you would do this:

sort=-date, sort=title

Expand  

 

[suntrop]

I know. The problem is it doesn't seem to work with checkboxes.

[maxf5]

Hm, okay. Maybe then make two arrays and merge them / prepend the array with checkboxes?

<?php 
$withcheckbox = $page->children("checkboxname=1"); 
$others = $page->children("checkboxname=0, sort=-chiffre");
$all = $withcheckbox->import($others);

foreach($all as $a) {
..
?>

 

[suntrop]

I thought it is possible within one selector … and I only have to rewrite my selector. 

My other solution looks better

$page->children('highlight=1, sort=-chiffre')->add( $page->children('highlight=0, sort=-chiffre') )

 

[maxf5]

thats fine i think!  didn't had in mind ->add works for arrays

  Quote

Add the given $item. Supports import of page arrays (since 2.2)

Expand  

 

[Robin S]

  On 10/23/2017 at 6:50 PM, suntrop said:

The problem is it doesn't seem to work with checkboxes.

Expand  

It's working for me. I assume the code in your first post is just for demonstration, but double-check that you are using the name of your checkbox field in the selector, i.e. "sort=highlight" and not "sort=checkbox". And you will want to reverse the sort for the checkbox to have checked items appear first: "sort=-highlight".

[suntrop]

HI Robin. Thanks for checking. But I can't get this to work, double checked my wording. I am using PW 3.0.78. Perhaps we are using other "checkbox modules"? How can I tell what module this checkbox field is exactly? I am pretty sure I have not installed any module like this … but possibly I am wrong  

[Robin S]

  On 10/26/2017 at 1:28 PM, suntrop said:

Perhaps we are using other "checkbox modules"?

Expand  

I tested with the core Checkbox fieldtype. You can check the fieldtype by opening the field (Setup > Fields > Your field) and looking in the Type dropdown.

Not sure why it wouldn't work for you, but there is no real harm in just sticking with what you are doing (combining two PageArrays together) unless you have a huge number of children.