CODEWITHSUNDEEP
phpcakephp
Vui Dang
Vui Dang

Reputation: 158

Select hasMany association cakephp3 not working?

i have 2 table users and user_stories users hasMany user_stories

users struct

id | name

user_stories

id | user_id | story_name

at UsersTable $this->hasMany('UserStories')->setForeignKey('user_id ');

at UserStories $this->belongsTo('Users')->setForeignKey('user_id');

$query = $this->find();
$query->contain([
    'UserStories'
])->select([
    'UserStories.name'
]);

Error unknown column UserStories.name

Upvotes: 1

Views: 486

Answers (1)

tarikul05
tarikul05

Reputation: 1913

You can select fields in contain section 

$query = $this->find();
$query->contain([
    'UserStories' [
        'fields' => [
            'UserStories.name'
        ]
    ]
]);

More info check Eager Loading Associations Via Contain

Upvotes: 2

Related Questions