Person Photos in Rock

Person photos in your Rock system literally change the way you see ministry. Records become individuals. Rock has several tools to make the collection of photos simple. We'd recommend that you consider some of the available core Rock tools (https://community.rockrms.com/documentation/bookcontent/5#photorequests) and plan to implement them.

You might want to keep an eye on how many people in your database have photos. The SQL below can be run in Rock using the SQL Command tool (Admin Tools > Power Tools > SQL Command) and will tell you what percentage of people in your system have photos. Hopefully this number will increase over time as you make use of Rock's tools for gathering photos.

SELECT
    SUM(
        CASE WHEN [PhotoId] IS NOT NULL
        THEN 1
        ELSE 0
        END
    ) * 100
    / COUNT(*) AS [PercentOfActiveRecordsWithPhotos]
FROM
    [Person]
WHERE 
    [RecordStatusValueId] = 3