Search by page->meta?

[Zeka]

Hi. 

Is there a way to find pages by $page->meta data? 

Thanks. 

[bernhard]

Only option I know is plain SQL:

<?php
// populate test value
$pages->get(1)->meta('foo', 'foo');

// find pages
$result = $database->query("SELECT source_id FROM pages_meta WHERE name = 'foo' and data = '\"foo\"'");
$ids = implode("|", $result->fetchAll(\PDO::FETCH_COLUMN, 0));
db($pages->find("id=$ids"));

If you use this with user input be sure to properly sanitize the data and maybe use prepared statements!

[adrian]

A couple of potential things - I think getByIDs would be more performant. And also, if you have JSON in the meta, then using JSON_VALUE might be helpful.