RegistrationLinksInfo

{% assign ri = PageParameter.RegistrationInstanceId %}

{% sql %}
SELECT RI.Id, RI.IsActive, L.UrlSlug, G.Name as GroupName
FROM
    [RegistrationInstance] RI LEFT JOIN
    [EventItemOccurrenceGroupMap] L ON RI.Id = L.RegistrationInstanceId -- L for Linkage
    LEFT JOIN [Group] G on G.Id = L.GroupId
WHERE RI.Id = {{ri}}
{% endsql %}

<div class="well">
<h4>Registration Links</h4>
{% for item in results %}
    {% if item.IsActive == 1 %}
        {% capture url %}{{ 'Global' | Attribute:'PublicApplicationRoot' }}Registration?RegistrationInstanceId={{ PageParameter.RegistrationInstanceId }}{% endcapture %}
        {% capture label %}Registration Link with no group placement:&nbsp{% endcapture %}
        {% if item.UrlSlug and item.UrlSlug != empty %}
            {% capture url %}{{url}}&Slug={{ item.UrlSlug }}{% endcapture %}
            {% capture label %} Link with placement group placement of {{item.GroupName}}:&nbsp{% endcapture %}
        {% endif %}
        <label class="control-label">{{label}}</label><a target="_blank" href="{{ url }}">{{url}}</a>
    {% endif %}
{% endfor %}

</div>