Find pages with grand children older than x days, but not newer than x days

[suntrop]

I was trying to get pages that have grand children older than 14 days, but not newer than 14 days.

$cities = wire('pages')->find('template=city, !children.children.created>"14 days ago"');

$cities = wire('pages')->find('template=city, children.children.created<"14 days ago"')->not('template=city, children.children.created>"14 days ago"');

$cities = wire('pages')->find('template=city, children.children.created<"14 days ago"')->remove('template=city, children.children.created>"14 days ago"');

The first one is, I guess, not supported by PW (not to mention something like created!>time), but the last two should work in my option. The filter() doesn't work either here.

Please note, that all city pages have grand children older than 14 days, so I can't just find('template=cities, children.children.created<"14 days ago"') because that includes those pages having grand children from yesterday for example.

[Robin S]

8 hours ago, suntrop said:

but the last two should work in my option. The filter() doesn't work either here.

Times as strings are not supported for in-memory selectors, only PageFinder (database) selectors. You'll need to use timestamps (e.g. via strtotime).

[suntrop]

Hadn't luck with timestamp either. Changed it now to this, and it's working for me. Anyway, thanks for your answer!

$remove = wire('pages')->find('template=city, children.children.created>"14 days ago"');
$cities = wire('pages')->find('template=city, children.children.created<"14 days ago"')->removeItems($remove);

 

[LostKobrakai]

Did you try:

$cities = wire('pages')->find('template=city, children.children.created<"14 days ago", !children.children.created>"14 days ago"')

Without the @ syntax the two selectors for children should work if they match on different children.

[suntrop]

1 hour ago, LostKobrakai said:

 

$cities = wire('pages')->find('template=city, children.children.created<"14 days ago", !children.children.created>"14 days ago"')

 

This one has a strange outcome. For example …

find('template=city, children.children.created<"14 days ago"');

Result:

• Hamburg
• Berlin
• Hannover
• Wiesbaden

 

find('template=city, children.children.created>"14 days ago"');

Result:

• Hamburg
• Bremen

 

find('template=city, children.children.created<"14 days ago", !children.children.created>"14 days ago"');

Result:

• Hamburg