You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I'm trying to query the gitlab_user table with users that are in a group: gitlab_group_member but I keep running into the same error. This is on gitlab.com:
Query 1 ERROR at Line 1: : ERROR: rpc error: code = Unknown desc = when using the gitlab_user table with GitLab Cloud, `List` call requires an '=' qualifier for one or more of the following columns: 'id', 'username'
This are the queries I tried:
SELECT
*
FROM
gitlab_group_member AS m,
gitlab_user AS u
WHERE
u.id = m.id
AND group_id = <group_id>;
SELECT
*
FROM (
SELECT
id AS group_member_id
FROM
gitlab_group_member
WHERE
group_id = <group_id>) AS m, gitlab_user
WHERE
id = group_member_id;
SELECT
*
FROM
gitlab_group_member AS m
JOIN gitlab_user AS u ON u.id = m.id
WHERE
group_id = <group_id>;
The text was updated successfully, but these errors were encountered:
Hi
I'm trying to query the gitlab_user table with users that are in a group: gitlab_group_member but I keep running into the same error. This is on gitlab.com:
This are the queries I tried:
The text was updated successfully, but these errors were encountered: