Question

Photo of DJ Grick

0

Public Prayer Requests

1

When setting up the prayer request submission block there is an option to allow the requests to be public. Is there any easy way that anyone has found to allow the public requests to show up on the public site? I looked at the manual and played with blocks but didn't figure it out. 

  • Photo of Jeremy Turgeon

    3

    We've setup a Dynamic Data block to pull the 4 most recent approved requests using this SQL script:

    SELECT TOP 4 *
    FROM [PrayerRequest]
    WHERE [IsApproved] = 1
    AND [IsPublic] = 1

    ORDER BY Id DESC

    It can then be formatted using lava to make it look better. :)  Here's a page we setup to do this: https://prayer.belairpres.org/page/5480

    Hope that helps!