Get page children by children's field value

[grigorisk]

Hi!
I have many pages-childrens of my main page with name=rates and i want to get all the childrens of my rates page by their input field value.
My input field is checkbox and i want to get the page if checkbox is checked.
Any help?

[Tom.]

$children = $pages->find('parent=/path/to/parent/, checkbox=1');

foreach($children as $child) {
}

Is this what you are looking for?

[DaveP]

If I understand your question correctly something like this should work.

$foo = $pages->get("name=rates")->children("checkbox=1");

I see Tom got there before me, and we are heading along similar lines.

[grigorisk]

i try both but nothing...

my page tree is (i can't upload image so i'll describe it...)

pricing (my parent page)

     heraklion (1st child)
            heraklion pricelist1(1st child of heraklion)
             .
             .
             .

     Chania (2nd child)
           chania pricelist1(1st child of chania)
           chania pricelist2(2nd child of chania)
             .

             .
             .
     .

     .
     .

and i want to get all the children of the pricing page (heraklion, heraklion pricelist, chania, chania pricelist,....) if their checkbox is checked

[LostKobrakai]

Something like that?

$children_of_price_lists =  $pages->get("parent=[has_parent=/pricing/, template=pricelist], my_checkbox=1"); 

[grigorisk]

i found a solution:

$my_page=$pages->get("name=pricing"); // get pricing

$childrens = $my_page->children; //get childrens

foreach ($childrens as $children){

$tables = $children->children("fcheckbox=1"); // get the childrens with checked checkbox

foreach ($tables as $locationTable){

.

.

.

}

}

[LostKobrakai]

You could have this in a single selector like so:

$tables = $pages->find("fcheckbox=1, parent=[parent.name=pricing]");

[grigorisk]

thank you LostKobrakai