orderBy() function is not working when delete() function is used in query builder.

I've looked in to your situation and i could say that ->orderBy not taken into delete query account is a bug.

In order to benefit from CodeIgniter deleted_at perks: your temporary solution for you would be along thous lines:

PHP Code:

$deleted_results = array_map(
    # Delete each row in select query result 1 by 1.
    fn ($x) => $this->db->table('my_table')->where('primary_key', $x['primary_key'])->limit(1)->delete(),

    # Query to select rows for deletion.
    $this->db->table('my_table')
        ->select('primary_key')
        ->where([
            'my_type' => 1
            ])
        ->orderBy('updated', 'DESC')
        ->get(reset: true)->getResultArray() ?? []
); 


Hope it helps someone!