Skip to main content

Sample Dashlets

This section collects a set of sample dashlets you can copy and adjust to implement your own needs.

Display hello message

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.

Select documents with a specific extended attribute

 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

List all the invoices with a custom visualization

#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).