Custom Connection Request List

{%- assign person = Context.Person -%}
{% assign personId = person.Id %}

//- PastoralCare =  RSR - Pastoral Care Team
{% assign isInPastoralCareRole = CurrentPerson | IsInSecurityRole: 178443 %}
{% assign isInRockAdminRole = CurrentPerson | IsInSecurityRole: 2 %}
{% if isInPastoralCareRole == true or isInRockAdminRole == true %}

<div class="card card-profile overflow-hidden">
    <div class="card-header dflex justify-content-between"><span>Pastoral Care Requests</span><span>State</span></div>
{% connectionrequest expression:'PersonAlias.PersonId  == "{{personId}}" and ConnectionOpportunityId = 11' securityenabled:'true' prefetchattributes:'Categories' %}
    {% assign connectionrequestItemsSize = connectionrequestItems | Size %}
    {% for connectionrequest in connectionrequestItems %}
        {% connectiontype id:'{{connectionrequest.ConnectionTypeId}}' securityenabled:'false' %}
        <dl class="{% cycle 'm-0 px-3 py-3 d-flex justify-content-between text-sm font-medium', 'bg-gray-100 m-0 px-3 py-3 d-flex justify-content-between text-sm font-medium' %}">
            <dt class="text-gray-900">
                <a href="/page/{{connectiontype.ConnectionRequestDetailPageId}}?ConnectionRequestId={{ connectionrequest.Id }}&ConnectionOpportunityId={{ connectionrequest.ConnectionOpportunityId }}">
                    {{ connectionrequest | Attribute:'Categories' }}
                </a>
                <dd class="">{% case connectionrequest.ConnectionState %}
                    {% when 'Active' %}
                        Active
                    {% when 'Inactive' %}
                        Moved to History (Inactivated)
                    {% else %}
                        connectionrequest.ConnectionState
                    {% endcase %}
                </dd>
            </dt>
        </dl>
        {% endconnectiontype %}
    {% endfor %}
    {% if connectionrequestItemsSize == 0 %}
        <dt class="text-gray-900">
        <dd class="">&nbsp;</dd>
        </dt>
    {% endif %}
{% endconnectionrequest %}
</div>
{% endif %}

<div class="card card-profile overflow-hidden">
    <div class="card-header dflex justify-content-between"><span>Connection Requests</span><span>State / Status</span></div>
{% connectionrequest expression:'PersonAlias.PersonId  == "{{personId}}" and ConnectionOpportunityId <> 11' securityenabled:'true' disableattributeprefetch:'true' %}
    {% assign connectionrequestItemsSize = connectionrequestItems | Size %}
    {% for connectionrequest in connectionrequestItems %}

        {% connectiontype id:'{{connectionrequest.ConnectionTypeId}}' securityenabled:'false' %}

        <dl class="{% cycle 'm-0 px-3 py-3 d-flex justify-content-between text-sm font-medium', 'bg-gray-100 m-0 px-3 py-3 d-flex justify-content-between text-sm font-medium' %}">
            <dt class="text-gray-900">
                <a href="/page/{{connectiontype.ConnectionRequestDetailPageId}}?ConnectionRequestId={{ connectionrequest.Id }}&ConnectionOpportunityId={{ connectionrequest.ConnectionOpportunityId }}">
                    {{ connectionrequest.ConnectionOpportunity.Name }}
                </a>
                <dd class="">{{ connectionrequest.ConnectionState }} / {{ connectionrequest.ConnectionStatus }}
                </dd>
            </dt>

        </dl>
        {% endconnectiontype %}
    {% endfor %}
    {% if connectionrequestItemsSize == 0 %}
        <dt class="text-gray-900">
        <dd class="">&nbsp;</dd>
        </dt>
    {% endif %}
{% endconnectionrequest %}
</div>