[Unicode]   Common Locale Data Repository : Bug Tracking Home | Site Map | Search
 
Modify

CLDR Ticket #11947(new)

Opened 8 days ago

Exclude anonymous users from tc-emaillist

Reported by: tbishop Owned by: tbishop
Component: surveytool-other Data Locale:
Phase: dsub Review:
Weeks: Data Xpath:
Xref:

Description

As Rick noticed, anonymous users are included here but shouldn't be:

http://st.unicode.org/cldr-apps/v#tc-emaillist///

The implementation is here in SurveyAjax.java:

                    } else if (what.equals(WHAT_PARTICIPATING_USERS)) {
                        assertHasUser(mySession);
                        assertIsTC(mySession);
                        JSONWriter r = newJSONStatusQuick(sm);
                        final String sql = "select cldr_users.id as id, cldr_users.email as email, cldr_users.org as org from cldr_users, "
                            + DBUtils.Table.VOTE_VALUE + " where "
                            + DBUtils.Table.VOTE_VALUE + ".submitter = cldr_users.id and " + DBUtils.Table.VOTE_VALUE
                            + ".submitter is not null group by email order by cldr_users.email";
                        JSONObject query = DBUtils.queryToCachedJSON(what, 3600 * 1000, sql); // update hourly
                        r.put(what, query);
                        addGeneralStats(r);
                        send(r, out);

That should be filtered to remove anonymous users, something like:

	+ "and cldr_users.userlevel != " + UserRegistry.ANONYMOUS

Attachments

View

Add a comment

Modify Ticket

Action
as new
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.