Mokatchi Comments - Answer Overflow

Mokatchi

•Created by Mokatchi on 3/20/2025 in #❓┊help

SoftDeletes

yep, but it took me several days to know that the tabs and trashedFilter are conflicted. I didn't know that the filter was applied automatically.

49 replies

FFilament

•Created by Mokatchi on 3/20/2025 in #❓┊help

SoftDeletes

The problem was there, because of the trashedFilter, it's applied automatically and it excludes the the trashed records by default. When I get ride of it, things work perfectly as expected.

49 replies

FFilament

•Created by Mokatchi on 3/20/2025 in #❓┊help

SoftDeletes

The problem wasn't about version updates as I was thinking,

49 replies

FFilament

•Created by Mokatchi on 3/20/2025 in #❓┊help

SoftDeletes

Thank you so much about your concern, but I already tried this solution too and nothing worked. the strange thing is that my code was working correctlly on the date mentionned above, but lately it dosn't work.

49 replies

FFilament

•Created by Mokatchi on 3/20/2025 in #❓┊help

SoftDeletes

@toeknee @Dan Harrin @Dennis Koch @Hassan Zahirnia @Saade

49 replies

FFilament

•Created by Mokatchi on 3/20/2025 in #❓┊help

SoftDeletes

I tried several solutions, but the issue still persists. Isn'it something about the core or new update? Because that was working before on January 24th 2025 !?

49 replies

FFilament

•Created by Mokatchi on 3/20/2025 in #❓┊help

SoftDeletes

I sent them to your account privately

49 replies

FFilament

•Created by Mokatchi on 3/20/2025 in #❓┊help

SoftDeletes

okay, can I do it privately? to your account directly?

49 replies

FFilament

•Created by Mokatchi on 3/20/2025 in #❓┊help

SoftDeletes

I don't know why the last line is added on all queries (all, active or archived)

49 replies

FFilament

•Created by Mokatchi on 3/20/2025 in #❓┊help

SoftDeletes

Using telescope, I found the following

select
  count(*) as aggregate
from
  `table`
where
  `table`.`deleted_at` is not null
  and (`table`.`deleted_at` is null)

select
  count(*) as aggregate
from
  `table`
where
  `table`.`deleted_at` is not null
  and (`table`.`deleted_at` is null)

49 replies

FFilament

•Created by Mokatchi on 3/20/2025 in #❓┊help

SoftDeletes

not yet, I'm seeing how to use it. I'm only using the dd() for the moment

49 replies

FFilament

•Created by Mokatchi on 3/20/2025 in #❓┊help

SoftDeletes

I tried your suggestion, but still get the same results, the deleted records aren't displayed

49 replies

FFilament

•Created by Mokatchi on 3/20/2025 in #❓┊help

SoftDeletes

Is it something like this?

class UserScope implements Scope
{
    public function apply(Builder $builder, Model $model)
    {
        if (Auth::check()) {
            $builder->where('user_id', Auth::id());
        }
    }
}

class UserScope implements Scope
{
    public function apply(Builder $builder, Model $model)
    {
        if (Auth::check()) {
            $builder->where('user_id', Auth::id());
        }
    }
}

49 replies

FFilament

•Created by Mokatchi on 3/20/2025 in #❓┊help

SoftDeletes

How can I do this "I would suggest you scope the model to the user by default"?

49 replies

FFilament

•Created by Mokatchi on 3/20/2025 in #❓┊help

SoftDeletes

I also replaced the query () by this ->modifyQueryUsing(fn (Builder $query) => $query->withoutGlobalScopes([SoftDeletingScope::class]) but still not working

49 replies

FFilament

•Created by Mokatchi on 3/20/2025 in #❓┊help

SoftDeletes

by the way, when I'm using the TrashedFilter results I'm gettung are right

49 replies

FFilament

•Created by Mokatchi on 3/20/2025 in #❓┊help

SoftDeletes

I used the withoutGlobalScopes([SoftDeletingScope::class]) to force the query to select all the entries from the db, but still not working.

49 replies

FFilament

•Created by Mokatchi on 3/20/2025 in #❓┊help

SoftDeletes

Actually I have another local scope on my model "scopeVisibleToUser" and I'm using it on the table query, so I can personalize the data display of each user. Here is the code of the table:

public static function table(Table $table): Table
    {
        $user = auth()->user();
        return $table
          ->query(parent::getEloquentQuery()
                    ->withoutGlobalScopes([SoftDeletingScope::class])
                    ->visibleToUser($user)->where(function (Builder $query) { ..... })
                  )
          ->columns([
                TextColumn::make('name')           
                ....
                )]
           ->filters([
                TrashedFilter::make(),
                SelectFilter::make('type')
                )];
    }

public static function table(Table $table): Table
    {
        $user = auth()->user();
        return $table
          ->query(parent::getEloquentQuery()
                    ->withoutGlobalScopes([SoftDeletingScope::class])
                    ->visibleToUser($user)->where(function (Builder $query) { ..... })
                  )
          ->columns([
                TextColumn::make('name')           
                ....
                )]
           ->filters([
                TrashedFilter::make(),
                SelectFilter::make('type')
                )];
    }

49 replies

FFilament

•Created by Mokatchi on 3/20/2025 in #❓┊help

SoftDeletes

Here is my tabs code:

public function getTabs(): array
    {
        return [
           'all' => Tab::make()
                  ->label(__('projProg.all'))
                  ->modifyQueryUsing(fn (Builder $query) => $query->withTrashed()),
           'active' => Tab::make()
                  ->label(__('projProg.active'))
                  ->modifyQueryUsing(fn (Builder $query) => $query->withoutTrashed()),
           'archived' => Tab::make()
                  ->label(__('projProg.archived'))
                  ->modifyQueryUsing(fn (Builder $query) => $query->onlyTrashed()),
        ];
    }

public function getTabs(): array
    {
        return [
           'all' => Tab::make()
                  ->label(__('projProg.all'))
                  ->modifyQueryUsing(fn (Builder $query) => $query->withTrashed()),
           'active' => Tab::make()
                  ->label(__('projProg.active'))
                  ->modifyQueryUsing(fn (Builder $query) => $query->withoutTrashed()),
           'archived' => Tab::make()
                  ->label(__('projProg.archived'))
                  ->modifyQueryUsing(fn (Builder $query) => $query->onlyTrashed()),
        ];
    }

49 replies

FFilament

•Created by Mokatchi on 3/20/2025 in #❓┊help

SoftDeletes

the sql query that I'm getting what ever is the tab selected is: select * from table where table.deleted_at is null

49 replies

Gaming

Programming