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