Question

Photo of Kelley Langkamp

0

Dynamic block with person report communications button isn't working

I'm not sure if this is a bug or if it's something I'm doing wrong. I have a dynamic block that pulls a list of first time attenders from the previous weekend. The Person Report box is checked in the block settings. The export, bulk update and merge buttons work but the communications button does nothing. The selected records have valid email addresses. The communications button works for me in other places (reports and data views). Here is the SQL query if anyone wants to try to recreate my problem.

SELECT
    c.[Name],p.[id],p.[NickName],p.[LastName],CAST(LEFT(av.[Value],22) AS DATETIME) AS Date,p.[Email]
FROM
    [GroupMember] gm
    INNER JOIN [Group] g ON gm.[GroupId] = g.[Id]
    INNER JOIN [Person] p ON gm.[PersonId] = p.[Id]
    INNER JOIN dbo.[Campus] c ON g.[CampusId] = c.[Id]
    INNER JOIN dbo.PersonAlias pa ON p.[Guid] = pa.[AliasPersonGuid]
    INNER JOIN dbo.GroupType gt ON g.[GroupTypeId] = gt.[Id]
    JOIN [AttributeValue] av ON p.[Id] = av.[EntityId] 
    

WHERE
    gt.[Guid] = '790E3215-3B10-442B-AF69-616C0DCB998E'
    AND av.[AttributeId] = '717'
    AND av.[Value] BETWEEN CONVERT(nvarchar(10), dateadd(day,-7,getdate()), 126) and CONVERT(nvarchar(10), getdate(), 126)
    AND c.[Name]=@CName;

  • Photo of Rock RMS

    0

    The [Id] field must start with a uppercase 'I' for the linking to work. The example in the documentation showed it as lowercase. This has been corrected.