Mrngstar
Mrngstar
PostsComments
FFilament
Created by Mrngstar on 8/24/2024 in #❓┊help
Edit Table Action only populating fields of the first row
Issue resolved with following query 
->query(Plan::where(function($query) {
        return $query
            ->whereIn('id', function($query){
                $query->select('plan_id')
                    ->from(with(new UserPlan)->getTable())
                    ->where('user_id', auth()->user()->id);
            })
            ->orWhere('is_private', 0);
    })
    ->orderBy('price', 'ASC')
)
->query(Plan::where(function($query) {
        return $query
            ->whereIn('id', function($query){
                $query->select('plan_id')
                    ->from(with(new UserPlan)->getTable())
                    ->where('user_id', auth()->user()->id);
            })
            ->orWhere('is_private', 0);
    })
    ->orderBy('price', 'ASC')
)
4 replies
FFilament
Created by Mrngstar on 8/24/2024 in #❓┊help
Edit Table Action only populating fields of the first row
Everything works properly when I use whereIn instead of orWhereIn. select * from plans where id in (select plan_id from user_plans where user_id = 20) and is_private = 0 and plans.deleted_at is null order by price asc for above query, values of that specific rows are getting populating. select * from plans where (id in (select plan_id from user_plans where user_id = 20) or is_private = 0) and plans.deleted_at is null order by price asc For this query, when I click on any row's Edit action,value of only first row are getting populated.
4 replies