Mihai Doarna
7d88b0130c
* generate a unique name for TeamBinding and store it in the uid column * generate testdata * fix team binding name
26 lines
606 B
SQL
26 lines
606 B
SQL
SELECT
|
|
tm.id as id,
|
|
tm.uid as uid,
|
|
t.uid as team_uid,
|
|
t.id as team_id,
|
|
u.uid as user_uid,
|
|
u.id as user_id,
|
|
u.name,
|
|
u.email,
|
|
u.login,
|
|
tm.external,
|
|
tm.created,
|
|
tm.updated,
|
|
tm.permission
|
|
FROM {{ .Ident .TeamMemberTable }} tm
|
|
INNER JOIN {{ .Ident .TeamTable }} t ON tm.team_id = t.id
|
|
INNER JOIN {{ .Ident .UserTable }} u ON tm.user_id = u.id
|
|
WHERE
|
|
t.uid = {{ .Arg .Query.UID }}
|
|
{{- if .Query.Pagination.Continue }}
|
|
AND tm.id >= {{ .Arg .Query.Pagination.Continue }}
|
|
{{- end }}
|
|
AND tm.org_id = {{ .Arg .Query.OrgID }}
|
|
ORDER BY t.id ASC
|
|
LIMIT {{ .Arg .Query.Pagination.Limit }};
|