In the original code, line 128 is as follows: $ownerKey = $relationship->getOwnerKeyName();

However, HasOne relationship instances don't have a getOwnerKeyName method.

I've added case insensitive support for postgres queries. Mysql like's are case insensitive by default, but for postgres we have to use ILIKE operator to achieve that.

hi , i am trying to use this package for my prime vue front end . i am receiving the data like below :

{"global":{"value":"test","matchMode":"contains"},"name":{"value":"cis","matchMode":"contains"},"status":{"value":"123","matchMode":"equals"},"abbreviation":{"value":"","matchMode":"equals"},"services":{"value":"","matchMode":"contains"},"primary-pm":{"value":"","matchMode":"equals"},"primary-engineer":{"value":"","matchMode":"equals"}}

andd from url url :

{{baseUrl}}/customers?filters=%7B%22global%22:%7B%22value%22:%22test%22,%22matchMode%22:%22contains%22%7D,%22name%22:%7B%22value%22:%22cis%22,%22matchMode%22:%22contains%22%7D,%22status%22:%7B%22value%22:%22123%22,%22matchMode%22:%22equals%22%7D,%22abbreviation%22:%7B%22value%22:%22%22,%22matchMode%22:%22equals%22%7D,%22services%22:%7B%22value%22:%22%22,%22matchMode%22:%22contains%22%7D,%22primary-pm%22:%7B%22value%22:%22%22,%22matchMode%22:%22equals%22%7D,%22primary-engineer%22:%7B%22value%22:%22%22,%22matchMode%22:%22equals%22%7D%7D

and in my controller i have this :

 $list = PrimevueDatatables::of(Customer::query())->make();
        dd($list);

i want to know how should i pass the $request->get('filters') that i can use this package for filters . thanks in advance

Local filter does not seem support for value boolean especially for false / 0 value. for example when user has checkbox filter with true / false value. This issue is solved by using !== comparison for the value.

Hi. I get this error when trying to sort a column in my table which is loading from a many to many relationship.

Call to undefined method Illuminate\Database\Eloquent\Relations\BelongsToMany::getOwnerKeyName() /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php line 71

I tracked it and looks like method getOwnerKeyName() does not exist in belongsToMany relations take a look at /vendor/savannabits/primevue-datatables/src/PrimevueDatatables.php:128

Hi, I would like to be able to enable or disable casing. In postgres this can be done easily changing from LIKE to ILIKE also I would like to ignore accents on searchs if that is possible. Do you think you would be able to implement this or do you need some help?

Hi! Thanks for your work. I am trying to use json column with Laravel but I encountered some small issue with the json column relationships.

I have this set of data, notice the name is inside the json datatype column

User.php

public function country()
{
    return $this->belongsTo(Country::class);
}

Index.vue

const params = {
  params: {
    dt_params: JSON.stringify(lazyParams.value),
    searchable_columns: JSON.stringify(['name', 'email', 'country.data.name']),
  }
}

Unfortunately, it return this error when I load the datatable

Call to undefined relationship [data] on model [App\\Models\\Country].

Thanks.