maize-tech / laravel-searchable Goto Github PK

Hello,

I've encountered a breaking problem when parsing more than 1000 id's trough the scopeSearch function in the HasSearch trait.
In the documentation of eloquent they are telling to use whereIntegerInRaw instead of whereIn in a query builder if there are many keys.

This is how I solved it. I've made a copy of the HasSearch trait and i'm using it like this now. I don't know if this is something that concerns you but it would be great if this package would be compatible with queries where many keys are used in the scopeSearch function.

With kind regards,

Rick

Getting "Integrity constraint violation: 1052 Column 'created_at' in order clause is ambiguous" when trying to use search with belongsTo() relation

Laravel 8.41.0
PHP 8

Bellow is my model

class Transaction extends Model
{
use HasSearch;
use HasUser;
use HasFactory;

/**
 * Get the model's searchable attributes.
 *
 * @return array
 */
public function getSearchableAttributes(): array
{
    return [
        'type' => 2,
        'notes' => 10,
        'amount' => 9, 
        'customer.name', 
        'paymentType.name', 
    ];
}

/**
 * Get the Customer that owns the Transaction.
 */
public function customer()
{
    return $this->belongsTo(Customer::class)->withTrashed();
}

/**
 * Get the PaymentMethod that owns the Transaction.
 */
public function paymentType()
{
    return $this->belongsTo(PaymentType::class);
}

}