diff options
author | Daniel Calviño Sánchez <danxuliu@gmail.com> | 2020-12-23 20:50:51 +0300 |
---|---|---|
committer | Daniel Calviño Sánchez <danxuliu@gmail.com> | 2020-12-23 21:06:47 +0300 |
commit | 8b9cd91604a07cbef315bfa16f41d0f25f3df233 (patch) | |
tree | 71d5f337f3d942d9da826d530a62dccb6f4d3d69 /lib/Service | |
parent | 685020c1c3cd2ef2bc6941ce7a69d1e0bcbad3ac (diff) |
Fix query for participants not in a call
The sessions were left joined to the attendees, so all the attendees in
the conversation that were not active were not included in the result.
Signed-off-by: Daniel Calviño Sánchez <danxuliu@gmail.com>
Diffstat (limited to 'lib/Service')
-rw-r--r-- | lib/Service/ParticipantService.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/Service/ParticipantService.php b/lib/Service/ParticipantService.php index 3f0bf8635..2904e750a 100644 --- a/lib/Service/ParticipantService.php +++ b/lib/Service/ParticipantService.php @@ -687,9 +687,9 @@ class ParticipantService { $query = $this->connection->getQueryBuilder(); $query->select('a.actor_id') - ->from('talk_sessions', 's') + ->from('talk_attendees', 'a') ->leftJoin( - 's', 'talk_attendees', 'a', + 'a', 'talk_sessions', 's', $query->expr()->eq('s.attendee_id', 'a.id') ) ->where($query->expr()->eq('a.room_id', $query->createNamedParameter($room->getId(), IQueryBuilder::PARAM_INT))) |