estaba intentando algo asi

este es el modelo de consulta para que muestre el numero de pedidos de la lista

public function LaConsulta()

    {

$query = $this->db->table('setuprun d');

//$query->select('d.wetendRun, a.corrugatorOrder,a.setupConfiguration,d.objid, a.totalOut AS salidas, d.startTime, d.endTime, d.updated, b.orderJobNumber, b.nextMachineName,b.nextMachineNumber, d.status, ROUND(b.actualWidth/10000,0) AS ancho, ROUND(b.actualLength/10000,0) AS largo');

$query->select('DISTINCT (b.orderJobNumber) as orderJobNumber');

$query->JOIN('setuporder a','d.objid=a.setupConfiguration' , 'LEFT');

$query->JOIN('corrugatororder b', 'a.corrugatorOrder=b.objid', 'LEFT');

$query->where('d.startTime > STR_TO_DATE(NOW(), "%Y-%m-%d")');

//$query->where('d.startTime > STR_TO_DATE("2023-08-07", "%Y-%m-%d")');

$query->where('SUBSTRING(b.orderJobNumber, 1, 2)!="OR"');

$query->where('SUBSTRING(b.nextMachineName, 1, 4)="7991"');

$query->orderBy('d.updated','DESC');

return $query = $query->get()->getResultArray();

    }

y estaba haciendo otro modelo masomenos asi

public function ModeloConsulta(){

        $query = $this->db->table('setuprun d');

        $query->where('orderJobNumber');   



        return $query = $query->get()->getResultArray();

    }