1. Home
2. php - Limiting retrieved columns when using withPivot on belonsToMany relationship

536 votes

2 answers

php - Limiting retrieved columns when using withPivot on belonsToMany relationship

Get the solution ↓↓↓

Solution:

i think that the most straightforward way is to make independent relation based on the pivot table using pivot model:

class ShiftEmployee extends Pivot
{
    protected $table='shift_employee';
} 
Copy code

now the new relation in Shift Model:

class Shift extends Model
{
    public function shortlistedApplications()
    {
        return $this->hasMany(ShiftEmployee::class,'shift_id');
    }
 public function scopeWithShortlistedApplications($query)
    {
        $query->with('shortlistedApplications:shift_id,shortlisted');
    }
}
Copy code

now this new scope would bring the data you want

Undefined asked

2023-03-23

---

---

523

votes

Answer

Solution:

What I think you need is to only load theshortlisted attribute of your employee's application in yourscopeWithApllications:

public function scopeWithApplications($query)
{
    $query->with('applications.application:id,shortlisted');
}
Copy code

This will still return anApplication instance as a relationship, but will only load it'sshortlisted attribute. Then, after retrieval, you can map your collection in order to merge the application's attribute to your employee, if that's really important. But in terms of data shortage, this will do the trick.

Undefined answered

2023-03-23

Link to answer

---

---

269

votes

Answer

Solution:

In your application model use withPivot method. Like this:

public function applications(){
return $this->belongsToMany('App\Application')
    ->withPivot('shortlisted')
    ->withTimestamps();}
Copy code

You can use this link for more clear example https://laraveldaily.com/pivot-tables-and-many-to-many-relationships/

Undefined answered

2023-03-23

Link to answer

---

---

Source

Share

---

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

---

Similar questions

Find the answer in similar questions on our website.

347 Getting Class "mysqli" not found when using docker container to load mysql and php

760 php - How can I set a specific PhpSession Cookie for a webpage?

380 php - How to update a particular row using id in redbean

808 php - How to fix Connection failed: Access denied for user 'webroot'@'localhost' (using password: YES)

872 php - Indirect modification of overloaded property has no effect when I try to unset() from a multidimensional array

287 "Notice: Undefined variable", "Notice: Undefined index", "Warning: Undefined array key", and "Notice: Undefined offset" using PHP

701 php - PHPUnit test not sharing the entity manager with Symfony

890 php - How do I make this condition actually work, I am using woocommerce

735 php - String sort in alphabetic order in php8

266 Using HTML buttons in PHP loops

About the technologies asked in this question

PHP

PHP (from the English Hypertext Preprocessor - hypertext preprocessor) is a scripting programming language for developing web applications. Supported by most hosting providers, it is one of the most popular tools for creating dynamic websites. The PHP scripting language has gained wide popularity due to its processing speed, simplicity, cross-platform, functionality and distribution of source codes under its own license.
https://www.php.net/

Laravel

Laravel is a free open source PHP framework that came out in 2011. Since then, it has been able to become the framework of choice for web developers. One of the main reasons for this is that Laravel makes it easier, faster, and safer to develop complex web applications than any other framework.
https://laravel.com/

Welcome to webdevask.com

Welcome to the Q&A site for web developers. Here you can ask a question about the problem you are facing and get answers from other experts. We have created a user-friendly interface so that you can quickly and free of charge ask a question about a web programming problem. We also invite other experts to join our community and help other members who ask questions. In addition, you can use our search for questions with a solution.

Get answers to specific questions

Ask about the real problem you are facing. Describe in detail what you are doing and what you want to achieve.

Help Others Solve Their Issues

Our goal is to create a strong community in which everyone will support each other. If you find a question and know the answer to it, help others with your knowledge.