Property [kriyakalap] does not exist on this collection instance.

@Sinnbeck Basically I wanted to fetch value from school_bini table by comparing Kriyakalap which is also included in BiniyojanDetails table.

@rajan001 so you want to compare every single kriyakalap from the first query in the second query? Or one specific?

If you want to compare all of them, you should use a relationship

$school_data = school_bini::has('biniyojanDetails')->get();
        dd($school_data);

@Sinnbeck yes, compare every kriyakalap

@rajan001 then use a relationship or a join (unless BiniyojanDetails only has like 10 rows or something)

@Sinnbeck and how to do with one specific?

@rajan001 one of

$biniyojan = BiniyojanDetails::first();//first record 
        $school_data = school_bini::where('kriyakalap', $biniyojan->kriyakalap)->get();
        dd($school_data);

//or
$biniyojan = BiniyojanDetails::find(32); //get specific record 
        $school_data = school_bini::where('kriyakalap', $biniyojan->kriyakalap)->get();
        dd($school_data);

Or in theory if you have few records in the first query

$biniyojan = BiniyojanDetails::pluck('kriyakalap');
        $school_data = school_bini::whereIn('kriyakalap', $biniyojan)->get();
        dd($school_data);

@Sinnbeck Okay i'll try these methods and get back to you.

@rajan001 Yo can use it just like this

$biniyojan = BiniyojanDetails::get['kriyakalap', 'id'];
        $school_data = school_bini::whereIn('kriyakalap', $biniyojan->kriyakalap)->get();
        dd($school_data);

@Sinnbeck @shivamyadav i have tried this method and got the result but it only gets first value but i want to all. When i use get() error is same.

public function SchoolReportToAdmin()
    {
        $biniyojan = BiniyojanDetails::first('kriyakalap','school_id');
        $school_data = school_bini::where(['kriyakalap' => $biniyojan->kriyakalap],['school_id' => $biniyojan->school_id])->get();
        dd($school_data);
        return view('schoolDataToAdmin',compact('school_data'));
    }

@rajan001 try this

	public function SchoolReportToAdmin()
    {
        $biniyojan = BiniyojanDetails::get();
        $school_data = school_bini::whereIn('kriyakalap', $biniyojan->pluck('kriyakalap'))
			->whereIn('school_id', $biniyojan->pluck('school_id'))
			->get();
        dd($school_data);
        return view('schoolDataToAdmin',compact('school_data'));
    }

@SilenceBringer Thanks it worked.

@rajan001 I already gave this answer earlier? https://laracasts.com/discuss/channels/laravel/property-kriyakalap-does-not-exist-on-this-collection-instance?page=1&replyId=840156

@Sinnbeck yes thanks. I have one more condition in same code. I also want to fetch data from relation table but I'm getting same type of error for database relation 'Property [school_bini_tax] does not exist on this collection instance.' I have added with condition

    public function SchoolReportToAdmin()
    {
        $biniyojan = BiniyojanDetails::get();
        $school_data = school_bini::with('school_bini_tax')
            ->whereIn('kriyakalap', $biniyojan->pluck('kriyakalap'))
            ->whereIn('school_id', $biniyojan->pluck('school_id'))
            ->get();
        dd($school_data->school_bini_tax);
        return view('schoolDataToAdmin', compact('school_data'));
    }

sch_bini Relation Table

public function sch_bini(): BelongsTo
    {
        return $this->belongsTo(school_bini::class, 'id', 'sch_bini_id');
    }

school_bini_tax relation table

public function school_bini_tax(): HasMany
    {
        return $this->hasMany(School_bini_tax::class, 'sch_bini_id', 'id');
    }

@rajan001 Same problem again. Can I suggest watching the "Laravel 8 from scratch" videos? I can see you have some confusion with getting multiple items, and just 1.

You are again getting multiple items, so to get a column for all items

dd($school_data->pluck('school_bini_tax'));

@Sinnbeck Thanks