Method count

posthog/api/action.py:235–253

(self, request: request.Request, **kwargs)

    @action(methods=["GET"], detail=True)
    def count(self, request: request.Request, **kwargs) -> Response:
        action = self.get_object()
        # NOTE: never accepts cohort parameters so no need for explicit person_id_joined_alias
        query, params = format_action_filter(team_id=action.team_id, action=action)
        if query == "":
            return Response({"count": 0})

        results = sync_execute(
            "SELECT count(1) FROM events WHERE team_id = %(team_id)s AND timestamp < %(before)s AND timestamp > %(after)s AND {}".format(
                query
            ),
            {
                "team_id": action.team_id,
                "before": now().strftime("%Y-%m-%d %H:%M:%S.%f"),
                "after": (now() - relativedelta(months=3)).strftime("%Y-%m-%d %H:%M:%S.%f"),
                **params,
            },
        )
        return Response({"count": results[0][0]})


class LegacyActionViewSet(ActionViewSet):