get, find, list – parameters

get

$article = $articles->get($id, contain: ['Comments']);

Opcje

finder 
conditions 
limit 
offset 
contain 
fields 
group 
having 
join

find – opcje, querybuilder

$query = $articles->find('all',
  conditions: ['Articles.created >' => new DateTime('-10 days')],
  contain: ['Authors', 'Comments'],
  limit: 10
);

$query = $articles->find('all')
    ->where(['Articles.created >' => new DateTime('-10 days')])
    ->contain(['Comments', 'Authors'])
    ->limit(10);

Listy

$query = $articles->find('list',
        keyField: 'id',
        valueField: function ($article) {
            return $article->author->get('label');
        }
    )
    ->contain('Authors');

$q = $proj_table->find('list', [
   'valueField' => function ($project) {
            return $project->number." - ".$project->name;
          }
      ]);
$q->where(['Projects.is_active' => 1]);
$q->order(['number']);
$project_list = $q->all();