Skip to content

Instantly share code, notes, and snippets.

@softwareloop
Created October 8, 2014 12:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save softwareloop/cda2e914c15655064741 to your computer and use it in GitHub Desktop.
Save softwareloop/cda2e914c15655064741 to your computer and use it in GitHub Desktop.
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