We're updating the issue view to help you get more done. 

Exclude anonymous users from tc-emaillist

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:

1 2 3 4 5 6 7 8 9 10 11 12 } 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:

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

Environment

xpath

None

locale

None

Status

Assignee

Thomas Bishop

Reporter

Thomas Bishop

tracReporter

tbishop

tracOwner

tbishop

tracStatus

new

phase

dsub

tracCreated

Mar 16, 2019, 9:06 PM

Components

Fix versions

Priority

assess