How do I add Last Registration date to the Pending Profiles report?

Question

Originally posted by Unknown

We have a lot of profiles that come in as pending when people register for an event and either they are not part of Rock or they entered different information that what we have in Rock. I'd like to know how I can get the date of the last event they registered for to be a column in the Pending Profiles report.

Answer 1

Originally posted by Unknown

This will only work IF your registrations add a timeline note after a person registers.

On your report, add a 'Lava' field. Rename the field to whatever you want the column header to say.

Add the following lava into your field. NOTE - You'll need to make sure that you've also included the 'Id' in your report. It can be set to 'Not Show in Grid' but you'll need that Id for the lava.

{% assign pid = Id %}

{% note where:'EntityId == {{ pid }} && NoteTypeId == 5' sort:'CreatedDateTime DESC' limit:'1' %}

{{ note.CreatedDateTime | Date: 'MM/dd/yyyy' }}

{% endnote %}