Notes

{% fetchxml accDetailsQuery %}
<fetch mapping='logical'>
<entity name='appstore_accelerator'>
<attribute name='appstore_name' />
<attribute name='appstore_description' />
<attribute name='appstore_avgrating' />
<attribute name='appstore_videolink' />
<attribute name='appstore_link' />
<attribute name='appstore_userguidelink' />
<attribute name='appstore_acceleratorstatus' />
<attribute name='appstore_productcategory' />
<attribute name='appstore_serviceline' />
<filter type='and'>
<condition attribute='appstore_acceleratorid' operator='eq' value="{{request.params['acceleratorid']}}" />
</filter>
</entity>
</fetch>
{% endfetchxml %}

{% fetchxml mappingQuery %}
<fetch distinct="true" mapping="logical" output-format="xml-platform" version="1.0" returntotalrecordcount="true">
<entity name='appstore_mappingreviewertoservicelineandproductcategory'>
<!-- Select the ID of the mapping record -->
<attribute name='appstore_mappingreviewertoservicelineandproductcategoryid' />
<filter type='and'>
<!-- Filter by the provided Product Category value -->
<condition attribute='appstore_productandservices' operator='eq' value="{{ accDetailsQuery.results.entities[0]['appstore_productcategory'] }}" />
<!-- Filter by the provided Service Line value -->
<condition attribute='appstore_serviceline' operator='eq' value="{{ accDetailsQuery.results.entities[0]['appstore_serviceline'] }}" />
</filter>
</entity>
</fetch>
{% endfetchxml %}


{% fetchxml getContactsMapping %}
<fetch distinct="true" mapping="logical" output-format="xml-platform" version="1.0" >
<entity name="contact">
<!-- <attribute name="emailaddress1" />
<attribute name="fullname" /> -->
<attribute name="contactid" />
<link-entity name="appstore_mappingreviewertoservicelinetocontact" from="contactid" to="contactid" link-type="inner" intersect="true">
<filter>
<condition attribute="appstore_mappingreviewertoservicelineandproductcategoryid" operator="eq" value="{{ mappingQuery.results.entities[0]['appstore_mappingreviewertoservicelineandproductcategoryid'] }} "/>
</filter>
</link-entity>
</entity>
</fetch>
{% endfetchxml %}


{% assign matchedContact = 0 %}

{% for contact in getContactsMapping.results.entities %}
{% if contact.contactid == user.contactid %}
{% assign matchedContact = 1 %}
{% break %}
{% endif %}
{% endfor %}