Confirmed users
1,201
edits
BMO/UserProfiles: Difference between revisions
Jump to navigation
Jump to search
→Data Points
| Line 169: | Line 169: | ||
* '''last_activity''' : from ''profiles.last_activity_ts'' | * '''last_activity''' : from ''profiles.last_activity_ts'' | ||
* '''bugs_filed''' : simple count from bugs table (public bugs only) | * '''bugs_filed''' : simple count from bugs table (public bugs only) | ||
* '''comments''' : simple count from | * '''comments''' : simple count from longdescs table (public comments only on public bugs) | ||
* '''commented_on''' : simple count from longdescs table (public comments only on public bugs) | |||
* '''confirmed''' : bugs_activity where field=status and removed='UNCONFIRMED' (public bugs only) | * '''confirmed''' : bugs_activity where field=status and removed='UNCONFIRMED' (public bugs only) | ||
* '''qa_contact''' : simple count from bugs table (public bugs only) | * '''qa_contact''' : simple count from bugs table (public bugs only) | ||
| Line 175: | Line 176: | ||
* '''reviews''' : review+ flags count (public bugs and attachments only) | * '''reviews''' : review+ flags count (public bugs and attachments only) | ||
* '''assigned''' : simple count from bugs table (public bugs only) | * '''assigned''' : simple count from bugs table (public bugs only) | ||
* '''touched''' : simple count from bugs_activity + | * '''touched''' : simple count from bugs_activity + longdescs table (public bugs, comments and attachments only) | ||
* '''by-status activity counters''' : simple count from bugs_activity table (public bugs only) | * '''by-status activity counters''' : simple count from bugs_activity table (public bugs only) | ||
* '''by-product activity counters''' : simple count from bugs_activity + | * '''by-product activity counters''' : simple count from bugs_activity + longdescs table (public bugs, comments and attachments only) | ||