When using the new filters how would you modify query based on Dot notation

[happymacarts]

for example my model has a relationship "info" if i wanted to modify the filter "where info.archive is null" what would that look like

public function filter(): array
{
  $filter = [
      [
        'name' => "Include  Archive",
        "id" => 1
      ], [
        'name' => "Without Archive",
        "id" => 2
      ]
  ];
  return [
    Dropdown::make('filter')
      ->label("Include Archive")
      ->data($filter),
  ];
}

public function query($query)
    {
        if ($this->getFilter('filter') && (int) $this->getFilter('filter') === 2) {
            return $query
                ->whereNull('info.archive') // <- how should i do this?
                ->with('user', 'status', 'info')
                ->withTrashed(); 
        }
        return $query->whereNotNull('info.archive')
            ->with('user', 'status', 'info')
            ->withTrashed();
    }

[wimurk]

Hi @happymacarts

I think you are trying to do a query on a relation? You can use the whereHas for that.

Check whereHas

public function query($query)
    {
        if ($this->getFilter('filter') && (int) $this->getFilter('filter') === 2) {
            return $query->whereHas('info', function($query){
                    $query->whereNull('archive');
                })->with('user', 'status', 'info')
                ->withTrashed(); 
        }
        return $query->whereDoesntHave('info', function($query){
                    $query->whereNull('archive');
                })
            ->with('user', 'status', 'info')
            ->withTrashed();
    }

[happymacarts]

exactly what I needed thx