How to get (pluck) name from a related table?

Hi @JabatoForever , Nope, i got "dictionary_geo": null

Any idea?

Tnx

@ictoplossing yes sorry, i didn't noticed your column does not follow Laravel conventions for relations so u should specify the foreign key name when defining the relation and should work

public function dictionaryGeo() {
    return $this->belongsTo(DictionaryGeo::class, 'dictionary_geos_id');
}

or as an alternative change the column name to be the singular of the table name and follow Laravel conventions so it would be dictionary_geo_id

Hi @JabatoForever , Now i get an error:

Call to undefined relationship [addresses] on model [App\Models\Person].

Model Person.php:

public function dictionaryGeo()
{
	return $this->belongsTo(DictionaryGeo::class, 'dictionary_geos_id');
}

PersonController.php:

$persons = Person::latest();

$persons = $persons
	->with([
		'personAddresses',
		'spokenLanguages',
		'createdByUser',
		'addresses.dictionaryGeo'
	])
	->get(['id', 'forename', 'name']);

If I use 'dictionaryGeo' (without 'addresses') I get dictionary_geo: null

Why?

@ictoplossing Error message is clear that you don't have any relation named addresses on your Person model.

Hi @DhPandya ,

I have this relation:

public function personAddresses()
    {
        return $this->belongsToMany(
            Address::class,
            'person_addresses'
        );
    }

This code return:

{
"id": 241,
"forename": "Johan",
"label": "Johan / Dutch",
"value": 241,
	"person_addresses": [
		{
			"id": 111,
			"name": "Stad",
			"dictionary_geos_id": 328,
		}
}

I need to get from a table 'dictionary_geos' postal code (column 'postcode') of the city by ID.

How to get it?

@ictoplossing Simply add your dictionaryGeo relation.

$persons = Person::latest();

$persons = $persons
	->with([
		'personAddresses',
		'spokenLanguages',
		'createdByUser',
		'dictionaryGeo'
	])
	->get(['id', 'forename', 'name']);

@DhPandya , Yes, I did it:

"dictionary_geo": null

I would like to get here postal code from the table 'dictionary_geos'

@ictoplossing Check your table if it is not following the naming convention of the Laravel then correct it manually with your model. You can also use hasMany. That directly points your table like Person has many addresses. (Just suggestion).

https://laravel.com/docs/10.x/eloquent-relationships#many-to-many-model-structure