List All Teams On Select Teams Page

Version number: 5.6.2

Summary

I’d like to know how to list all Teams on the select_team page.

Steps to reproduce

Once logged into Mattermost click the hamburger menu option ‘Join Another Team’.

I have determined that this only applies to System Admin users.

Hi @mrprice, are those other teams public/open teams? If they are private teams, you will not see them on the list of teams to join.

Hey @amy.blais,

When I’m configured as a Member I get the full list of ALL public/open teams. When I’m configured as a System Admin I get first 21 Teams only.

I’ve also been able to capture the queris in the log files.

If I’m a Member:
SELECT * FROM Teams WHERE AllowOpenInvite = true LIMIT $1 OFFEST $2

If I’m a System Admin:
SELECT * FROM Teams ORDER BY DisplayName LIMIT $1 OFFEST $2

Hi @mrprice, would you be able to test this on the latest Mattermost version? I believe Gitlab will be on Mattermost v5.10 in the next few days.

Hey @amy.blais I’ll giev that a try. Do you know which version of GitLab CE will have Mattermost v5.10?

11.11, the versions are also listed here: https://docs.gitlab.com/omnibus/gitlab-mattermost/#upgrading-gitlab-mattermost.

OK, I’ll see if I can test that once it’s available.

Upgrading to 11.11 fixed this. Thanks for your help.

I was incorrect. It lists more Teams now but not all.

I can see in the log that the parameters for the query are being set to 200 and 0.
SELECT * FROM Teams ORDER BY DisplayName LIMIT $1 OFFEST $2

Where are these settings?