Hi, It's very interesting project. Are You going to finish it ?

<a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/us

filterRelationship about joy-voyager-datatable HOT 2 CLOSED

rxcod9 commented on May 28, 2024

filterRelationship

from joy-voyager-datatable.

Comments (2)

rxcod9 commented on May 28, 2024

@sanvolter
Meanwhile you can create an scope for the data row field and it will work as filter

joy-voyager-datatable/src/Services/Filter.php

Line 37 in 24971aa

$query->scopes([

PRs are welcome 🙏

from joy-voyager-datatable.

sanvolter commented on May 28, 2024

Maybe it will be useful to someone:

protected function filterRelationship(
$query,
$keyword,
DataRow $row,
DataType $dataType,
Request $request
): void {

            $search_value = '%'.$keyword.'%';
            $search_filter = 'LIKE';
            $relationshipIds = [];
                if ($row->type == 'relationship' && isset($row->details) && $row->details->type == 'belongsTo'){
                        $relationshipIds = DB::table($row->details->table)
                            ->select($row->details->key, $row->details->label)
                            ->where($row->details->label, $search_filter, $search_value)
                            ->pluck($row->details->key)
                            ->toArray();
                }
                $query->whereIn($row->details->column,$relationshipIds);

}

from joy-voyager-datatable.

Recommend Projects