Sample Dashlets

Hello <b>$user.fullName</b>

[snippetnoeditor id="dashlet3" openLabel="Open dashlet" copyLabel="Copy to clipboard"][/snippet]

This basic dashlet of type custom content displays an hello message.

 from Document d join d.attributes v
where d.workflowStatus='Revision' 
  and d.creatorId in (1,114,113,116)
  and v.stringValue='Acme'
  and key(v) = 'Buyer'
order by d.date desc

[snippetnoeditor id="dashlet1" openLabel="Open dashlet" copyLabel="Copy to clipboard"][/snippet]

This dashlet of type documents select all the documents that match these criteria:

• creator user must be identified by 1, 114, 113 or 116
• workflow status must be Revision
• the extended attribute Buyer must be Acme

#set($documentDao = $ContextTool.getBean("DocumentDAO"))   
#set($invoices = $documentDao.findByWhere('_entity.template.id=547815424','_entity.date desc',10))
<table border="1">
<tr><th>InvoiceNo</th><th>Date</th><th>Total</th></tr>
#foreach( $doc in $invoices)
   $documentDao.initialize($doc)
   <tr>
       <td>$doc.getValue('InvoiceNo')</td>
       <td>${DateTool.format($doc.getValue('Date'),false)}</td>
       <td>$doc.getValue('Total')</td>
   </tr>
#end
</table>

[snippetnoeditor id="dashlet2" openLabel="Open dashlet" copyLabel="Copy to clipboard"][/snippet]

This dashlet of type custom content renders an HTML table with all the invoices(those documents with template identified by 547815424).