Sort by repeater checkbox

[dps123]

I'm trying to sort a $pages->find result by a checkbox value.

sort=my_repeater.my_checkbox

The idea is that I get pages with the checkbox unticked before pages with the checkbox ticked, i.e. 0 to 1. Because I haven't given my checkbox fields a name, they are using the field name. I can see in PW that the checkboxes are labelled

my_checkbox_repeater123456

So I think my sort is not working. Is there a way around this?

[LostKobrakai]

The id at the end of the field name is only used in the admin backend to have unique field names for each repeater otherwise they would overwrite each other on save. 

[dps123]

Oh, I see. So my sort should be working. Let me take a look and possibly post another question!

[dps123]

I can see there is an issue when I'm trying to sort pages by the repeater value. So when I'm doing

sort=my_repeater.my_checkbox

and wanting an order of 0 to 1, if there are no repeater items on a page, they are appearing first in my list. Can I do something for that?

[dps123]

Anyone?

[Robin S]

Does reversing the sort order help?

sort=-my_repeater.my_checkbox

[dps123]

Unfortunately not; that will give me checked items first. I'm just looking at this: https://processwire.com/talk/topic/3571-sorting-page-array-containing-pages-without-the-sort-field/, as that might be more like what I need.