{% assign personAliasId = CurrentPerson.PrimaryAliasId %}
{% sql %}
DECLARE @PersonAliasId INT = {{ personAliasId }};
SELECT
COUNT(cr.[Id]) AS UnreadReplyCount
FROM [CommunicationResponse] cr
LEFT JOIN [SystemPhoneNumber] spn
ON spn.[Id] = cr.[RelatedSmsFromSystemPhoneNumberId]
LEFT JOIN [PersonAlias] pa
ON pa.[Id] = spn.[AssignedToPersonAliasId]
WHERE (cr.[IsRead] = 0 OR cr.[IsRead] IS NULL)
AND cr.[RelatedSmsFromDefinedValueId] IS NOT NULL
AND pa.[Id] = @PersonAliasId
AND (spn.[IsSmsForwardingEnabled] = 0 OR spn.[IsSmsForwardingEnabled] IS NULL)
GROUP BY cr.[RelatedSmsFromDefinedValueId];
{% endsql %}
{% assign totalUnread = 0 %}
{% for row in results %}
{% assign totalUnread = totalUnread | Plus: row.UnreadReplyCount %}
{% endfor %}
{% if totalUnread > 0 %}
{{ totalUnread }}
{% endif %}
{% endif %}