All assets under a page

In this example we see all assets under a page. This can work out for articles on a page, but also for messages in a collaboration system or events in a calendar object. In this example we only look at pages, but you can adjust the classname to select ather assets.

The query will be:

SELECT
  title,
  url
FROM
  assetData,
  asset
WHERE
  asset.assetId=assetData.assetId
AND
  asset.className = 'WebGUI::Asset::Wobject::Layout'
AND
  assetData.revisionDate = 
    (SELECT 
      MAX(maxAssetData.revisionDate) 
     FROM assetData as maxAssetData 
     WHERE assetData.assetId=maxAssetData.assetId) 
AND
  parentId = 'QHUFqkozyZrFSe8gxNV5jw' 

The template will be:

<a name="id<tmpl_var assetId>" id="id<tmpl_var assetId>"></a>

<tmpl_if session.var.adminOn>
	<p><tmpl_var controls></p>
</tmpl_if>

<tmpl_if displayTitle>
	<h2><tmpl_var title></h2>
</tmpl_if>

<tmpl_if description>
	<tmpl_var description>
	<p />
</tmpl_if>

<tmpl_if debugMode>
	<ul>
	<tmpl_loop debug_loop>
		<li><tmpl_var debug.output></li>
	</tmpl_loop>
	</ul>
</tmpl_if>

<tmpl_loop rows_loop>
<a href="<tmpl_var row.field.title.value>"><tmpl_var row.field.title.value></a><br />
</tmpl_loop> 

Users
Collaboration System
Using placeholders & prequeries
WebGUI assets
Advanced examples