Category: Models & ORM
Q: How can I create subsquery of same query written in 2x
$conditionsSubQuery['Logs.title'] = $log_title;
$conditionsSubQuery['Logs.school_id'] = $school_id;
$db = $this->Log->getDataSource();
$subQuery = $db->buildStatement(
array(
'fields' => array('Logs.grade_id'),
'table' => $db->fullTableName($this->Log),
'alias' => 'Logs',
'limit' => null,
'offset' => null,
'joins' => array(),
'conditions' => $conditionsSubQuery,
'order' => null,
'group' => array('Logs.grade_id')
),
$this->Log
);
$subQuery = "Grade.id IN (" . $subQuery . ") ";
$dbgrade = $this->Grade->getDataSource();
$subQueryExpression = $dbgrade->expression($subQuery);
$conditions[] = $subQueryExpression;
$grade_lists = $this->Grade->find('list', array('conditions'=>$conditions,'recursive' => -1,'fields'=>array('Grade.id','Grade.name')));
cakephp0 Answers
No answers yet!
The community needs your help!
Created: 18 Jul '18
Last Reply: None
Replies: 0
Views: 5120
Votes: 0
Further Reading
Q: In Cakephp 3, how to get client's IP address?
Q: How to Hash::extract value from JSON data (utility class)
Q: How to implement the built-in mobile detect in Cakephp 3?
Q: Crossover design: CakePHP and Phalcon
Q: Cakephp 2 how to escape special characters to prevent SQL injection?
Q: RSS feed view in CakePHP 3
Q: In Cakephp 3, how to detect user from another site?
Q: How to prevent Oauth2 app key and secret hard-coded in CakePHP?
Q: Using cakephp/elastic-search with pagination