Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
alfresco-inboxes-example-cmis-queries
<inboxes>
<group id="CMIS examples">
<inbox id="All dossiers" iconClass="foundicon-folder">
<query><![CDATA[
SELECT *
FROM owd:dossier AS d
]]></query>
</inbox>
<inbox id="Pictures" iconClass="foundicon-address-book">
<query><![CDATA[
SELECT *
FROM owd:hrdocument
WHERE owd:hrDocumentType = 'Picture'
]]></query>
</inbox>
<inbox id="Active" iconClass="foundicon-checkmark">
<query><![CDATA[
SELECT *
FROM owd:dossier
WHERE owd:dossierStatus = 'Active'
]]></query>
</inbox>
<inbox id="Retired" iconClass="foundicon-remove">
<query><![CDATA[
SELECT *
FROM owd:dossier
WHERE owd:dossierStatus = 'Retired'
]]></query>
</inbox>
<inbox id="By mjackson" iconClass="foundicon-page">
<query><![CDATA[
SELECT *
FROM cmis:document
WHERE cmis:createdBy = 'mjackson'
]]></query>
</inbox>
</group>
<group id="Parameterised queries">
<inbox id="By myself" iconClass="foundicon-page">
<query><![CDATA[
SELECT *
FROM cmis:document
WHERE cmis:createdBy = '{userName}'
]]></query>
</inbox>
<inbox id="Modified this month" iconClass="foundicon-page">
<query><![CDATA[
SELECT *
FROM cmis:document
WHERE cmis:lastModificationDate >= '{monthStart}'
]]></query>
</inbox>
</group>
</inboxes>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment