Using an Iterator With a Custom Query - Mura Docs v6

Using an Iterator With a Custom Query

The Mura contentIterator can decorate any query that contains the columns "SiteID" and "ContentID".

<cfscript>
queryService=new Query();
queryService.setSQL(
'SELECT contentID, siteid
FROM tcontent
WHERE parentID = :parentID
AND siteID = :siteID
AND active = 1'
);
queryService.addParam(
name='parentID'
, cfsqltype='cf_sql_varchar'
, value=$.content('contentID')
);
queryService.addParam(
name='siteID'
, cfsqltype='cf_sql_varchar'
, value=$.content('siteID')
);
rs=queryService.execute().getResult();
iterator=$.getBean('contentIterator');
iterator.setQuery(rs);
</cfscript>
<cfoutput>
<cfif iterator.hasNext()>
<ul>
<cfloop condition="iterator.hasNext()">
<cfset item=iterator.next()>
<li>
<a href="#item.getURL()#">
#HTMLEditFormat(item.getMenuTitle())#
</a>
</li>
</cfloop>
</ul>
<cfelse>
<p class="alert alert-info">No items in the iterator!</p>
</cfif>
</cfoutput>