Hi Dyvel
Sorry for my answer time, on my phone it's more complicated to answer with a code
You are in the model, so the ORM system is simpler.
link to docs :
ORM Système → Relations→ Nested queries
I don't know your tables, but you can do something like this:
$this->orm(array(
'select' => array(
'end_date',
'ordering',
'start_date',
'teamnumber',
'title',
'venue',
'venue.title',
//add the FK spaceName for instructors
'instructors.user_id',
'instructors.first_name
),
'relation' => array(
//'relationModel' => selectArray
'indstructors' => array(
'select' => 'first_namename'
)
),
'filter' => array(
// Filter by FK
'instructors.user_id' => array(
'type' => 'fk'
),
)
));
think about changing nameSpace or relation name. I don't know your tables
It should work.
Nicolas
