How to create a filter using hasMany and hasOne?

Question

Yii

There are, for example, such linking tables with Ticket

public function getGroup()
    {
        return $this->hasOne(Group::className(), ['id' => 'group_id'])
      ->viaTable('{{%group_ticket}}', ['ticket_id'=>'id'])->where(['id'=>
      GroupTicket::find()->select('group_id')->where(['id'=>
      GroupTicket::find()->select('max(id)')->groupBy('ticket_id')
      ])

      ]);
    }

and

public function getGroupTickets()
    {
        return $this->hasMany(GroupTicket::className(), ['ticket_id' => 'id']);
    }

How to correctly register a filter in TicketSearch, is it more accurate to specify related tables?

Answer 1

$query = Ticket::find()->joinWith(['group', 'groupTickets']);
$query->where([
    'group.name' => $groupName, 
    'groupTickets.name' => $ticketName,
]);