Mrngstar Posts - Answer Overflow

Mrngstar

•Created by Mrngstar on 8/24/2024 in #❓┊help

Edit Table Action only populating fields of the first row

Below code works fine when I click on Edit action, fields of that row getting populated

->query(Plan::where('is_private', 0)
    ->orderBy('price', 'ASC')
)

->query(Plan::where('is_private', 0)
    ->orderBy('price', 'ASC')
)

But when I update the query and click on Edit for any row, fields of the first row are getting populated

->query(Plan::where('is_private', 0)
    ->orWhereIn('id', function($query){
        $query->select('plan_id')
            ->from(with(new UserPlan)->getTable())
            ->where('user_id', auth()->user()->id);
    })
    ->orderBy('price', 'ASC')
)

->query(Plan::where('is_private', 0)
    ->orWhereIn('id', function($query){
        $query->select('plan_id')
            ->from(with(new UserPlan)->getTable())
            ->where('user_id', auth()->user()->id);
    })
    ->orderBy('price', 'ASC')
)

My use case: I want to show public plans to all users and show private plan if its assigned to that user.

4 replies

Gaming

Programming