How to make OR statement with this :
How to make OR statement with this :
stancaballero
Posts: 29Questions: 9Answers: 0
in Select
->select( 'tbl_branchpersonel_master', ['tbl_branchpersonel_master.employee as value', 'tbl_branchpersonel_master.employee as label'], ['tbl_branchpersonel_master.regionname' => $_REQUEST['values']['tbl_branch_incentives_master.regionname'], 'tbl_branchpersonel_master.branchname' => $_REQUEST['values']['tbl_branch_incentives_master.branchname']], ['label ASC'] )
->fetchAll();
This question has an accepted answers - jump to answer
Answers
The
select()
method doesn't let you build an OR condition query. What you need to do is use the Query class long hand. Theselect()
method is basically:So you'd so something similar:
Allan
Thank you sir