Sample Dashlets

Select documents with a specific extended attribute

Print 
 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