I have an issue where a page includes a ‘CRM Data View’ widget that is not presenting any records. It has worked in the past (page is used annually in March-April). There has been an upgrade to our portal since then; not sure if this might be an issue.
The view uses a fetch which is dependent on values provided via the url that calls the page. No logon is required, the user is simply provided with the url which includes two parameters (e.g. …da.com/ext/member-topic-selection?gid=a20e5c5c-7b17-df11-b699-00155d015815&cid=abb2f0d2-4659-e311-9d89-00145edef66f).
A filter in the view is defined as “@GROUPID@~~~Querystring~~~gid”.
The query returns appropriate values in CRM.
The fetch looks like this:
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">
<entity name="ns_meetingsession">
<attribute name="ns_speakerpresentationid" />
<attribute name="ns_speakerid" />
<order attribute="ns_sessionstarttime" descending="true" />
<filter type="and">
<condition attribute="ns_sessionstarttime" operator="last-x-years" value="3" />
<condition attribute="statecode" operator="eq" value="0" />
<condition attribute="ns_type" operator="eq" value="1" />
<condition attribute="ns_speakerpresentationid" operator="not-null" />
</filter>
<link-entity name="ns_meeting" from="ns_meetingid" to="ns_meetingid" alias="ah">
<filter type="and">
<condition attribute="ns_group" uitype="ns_tecgroup" operator="eq" value="{@GROUPID@}" />
</filter>
</link-entity>
</entity>
</fetch>
Chris Lefsrud