How to cast ObjectId in Model, instead in where condition

[masterbater]

Is this correct? Its not working. but wrapping it

not working

WorkoutLogs::where('createdBy', '5be9ce7b3de6dd77db832950')->orderBy('createdAt', 'desc')->paginate(10);
protected $casts = [
       'createdBy' => ObjectId::class,
   ];

this works

WorkoutLogs::where('ruleType', 'Vitals')->where('createdBy', new BSONObjectId('5be9ce7b3de6dd77db832950'))->orderBy('createdAt', 'desc')->paginate(10);

[hans-thomas]

It's working fine for me.

$stringId = (string) (new ObjectId());
Client::query()->create(['cclient_id' => $stringId, 'name' => 'Young Gerald']);
Client::query()->where('cclient_id', $stringId)->first();

What version you are using?

[masterbater]

I need to do an auto casting fields into ObjectId, but they dont have it so I just use BSONObjectId to cast objectId, I do dynamic fields for where conditions so I just detect

  if (is_string($value) && preg_match('/^[0-9a-f]{24}$/i', $value) === 1) {
                // Check if the value is a valid BSONObjectId string and cast it
                $value = new BSONObjectId($value);
                $query->where($id, $value);
}

[hans-thomas]

While replicating this issue in a fresh project, please consider a not-reserved name for your id field. (the createdAt is reserved. try somethingCreatedAt)

[masterbater]

When querying the set wont be called, for solution, we just need to modify

$objectId= $this->convertToObjectId($objectIdString); //Supports conversion of string, array of string or collection of string
Client::query()->create(['cclient_id' => $objectId, 'name' => 'Young Gerald']);
Client::query()->where('cclient_id', $objectId)->first();

No checking of its valid objectid string since most of the source of objectid is from the collection itself

<?php

namespace App\Traits;


use MongoDB\BSON\ObjectId;


trait ObjectIdConversion
{
    public function convertToObjectId($value)
    {
        // Check if the value is an instance of ObjectId and skip conversion
        if ($value instanceof ObjectId) {
            return $value;
        }

        // Check if the value is a Collection
        if ($value instanceof \Illuminate\Support\Collection) {
            // Convert Collection to an array
            $value = $value->toArray();
        }

        // Check if the value is an array
        if (is_array($value)) {
            foreach ($value as $key => $item) {
                // Recursively call the function if the item is an array
                $value[$key] = $this->convertToObjectId($item);
            }
            return $value;
        } else {
            // Convert the value to an ObjectId
            return new ObjectId($value);
        }
    }
    public function convertObjectIdToString($value)
    {
        if ($value instanceof \Illuminate\Support\Collection) {
            // Convert Collection to an array
            $value = $value->toArray();
        }

        // Check if the value is an array
        if (is_array($value)) {
            foreach ($value as $key => $item) {
                // Recursively call the function if the item is an array
                $value[$key] = (string) $item;
            }
            return $value;
        } else {
            // Convert the value to an ObjectId
            return (string) $value;
        }
    }
   
}