group_start and or_group_start implementation

[eliasmcastro]

Hello, i'm trying to make some complex query but i'm facing some issues.

I'm using "group_start" in CodeIgniter, but when I use Ignited-Datatables I don't find "group_start" and "or_group_start", my query is complex and need of use "(" and ")". How fix the issue?

Thanks.

[wrabit]

You could open up the Datatables library and add the methods yourself:

    public function group_start($not = '', $type = 'AND ')
    {
      $this->ci->db->group_start($not, $type);
      return $this;
    }
    public function or_group_start()
    {
      $this->ci->db->or_group_start();
      return $this;
    }
    public function group_end()
    {
      $this->ci->db->group_end();
      return $this;
    }

[briansulzen]

Any idea how to get group_start and group_end methods to get the correct count in get_total_results? Generating the query works by adding the CI methods to the Datatables library as suggested by @wrabit , but the count generated by get_total_results is way off. Trying to come up with a solution that is not hacky to add group_start and group_end into get_total_results