Overview

This article is intended to provide information on why the result for the count of the members of a social group differs between the database and the API.

Information

The count of the members of a social group in Jive brings up different results when pulled from the database (using SELECT COUNT(*) FROM `jivesgroupmember` WHERE `groupid`={GROUP ID HERE}), and when pulled using API calls (to /members/places/{placeID} as detailed in Member Service under the Jive REST API documentation).

The reason for the difference is that the results from the API call do not include deactivated users in the count.