Codeigniter query to correctly encapsulate AND and OR conditions in a WHERE clause

Question

I want a CodeIgniter select query from a table with three conditions.

1. wrk_fld_exc = 140
2. wrk_cs_sts = 'Open'
3. wrk_dlvrd_sts = 'Delivered' OR wrk_cl_sts = 'Success'

The third condition is an AND condition contains an OR condition. First and second is an AND condition.

Answer 1

You can code it like this:

       $this->db->where('wrk_fld_exc',140);
       $this->db->where('wrk_cs_sts','open');
       $where = '(wrk_dlvrd_sts="open" or wrk_cl_sts = "Success")';
       $this->db->where($where);