438014 - Number of contributors cannot be displayed if > 500

Status: RESOLVED INCOMPLETE

(support.mozilla.org :: General, defect, P2)

Description

[Chris Ilias [:cilias]]

1. Go to http://support.mozilla.com/tiki-admingroups.php?group=Contributors
2. Click on "Members".

Result: "Members list is not shown because there are more than 500 members"

I don't need the actual list, but I do need to know the number of members.

Comment 1

[David Tenser [:djst]]

Can we simply increase the limit to 5000? The performance is only going to be affected when you're on this page, right?

Comment 2

[Chris Ilias [:cilias]]

Sure.

Comment 3

[Nelson Ko [:nkoth]]

Eric, If 5000 is ok, just do that.

Otherwise you need a new query to show the total number, but not actually the members.

Comment 4

[Chris Ilias [:cilias]]

Cheng, Matthew: I don't see anything on <https://docs.google.com/Doc?id=dd3xrkhv_5cv3brjhd&hl=en> WRT counting users. Can you provide a query to find out total number of users in each group. That's all I really want here. By counting the difference in totals each week, we should be able to fill in the "New Contributors" weekly metric.

Comment 5

[[:Cww]]

select date(FROM_UNIXTIME(min(uu.registrationDate))) as weekbeginning, count(distinct(uu.login)) as numnewcontribs from users_users uu join users_usergroups ug on uu.userId = ug.userId WHERE ug.groupName = 'Contributors' group by yearweek(FROM_UNIXTIME(uu.registrationDate)) order by weekbeginning DESC;
gives you # of contributors who registered each week (change group as needed)

select date(FROM_UNIXTIME(min(uu.lastLogin))) as weekbeginning, count(distinct(uu.login)) as numlogincontribs from users_users uu join users_usergroups ug on uu.userId = ug.userId WHERE ug.groupName = 'Contributors' group by yearweek(FROM_UNIXTIME(uu.lastLogin)) order by weekbeginning DESC;
gives you # of contributors who logged in each week (change group as needed)

select ug.groupName as group, count(distinct(uu.login)) as count from users_users uu join users_usergroups ug on uu.userId = ug.userId WHERE  FROM_UNIXTIME(uu.lastLogin) between '2009-02-01' and '2009-02-28' group by ug.groupName;
gives you number of logins by users in each group in Feb. 2009 (change dates as needed.

Comment 6

[[:Cww]]

We can add any of these queries to the weekly metrics run I do, just tell me what you need exactly.

Comment 7

[[:Cww]]

Correction, that last query isn't number of logins, it's number of users who logged in during last month.

Comment 8

[Laura Thomson :laura]

can't we just paginate?

required for productization milestone.