06-21-2014 10:36 AM
SELECT d.* FROM cmis:document d JOIN ws:webasset w ON w.cmis:objectId = d.cmis:objectId
WHERE
(d.cmis:name = 'name1.html' AND in_folder('${section:/root/folder1}'))
OR
(d.cmis:name = 'name2.html' AND in_folder('${section:/root/folder2}'))
SELECT d.* FROM cmis:document d JOIN ws:webasset w ON w.cmis:objectId = d.cmis:objectId
WHERE
(d.cmis:name = 'name1' OR d.cmis:name = 'name2.html')
AND
(in_folder('${section:/root/folder1}') OR in_folder('${section:/root/folder2}'))
06-24-2014 11:01 PM
SELECT D.*, O.* FROM cmis:document AS D JOIN cm:ownable AS O ON D.cmis:objectId = O.cmis:objectId
WHERE
(D.cmis:name = 'name1.html' AND IN_FOLDER(D,'workspace://SpacesStore/e1e67158-b8ce-4d6b-aa46-0cc05cee9366'))
OR
(D.cmis:name = 'name2.html' AND IN_FOLDER(D,'workspace://SpacesStore/e1e67158-b8ce-4d6b-aa46-0cc05cee9366'))
06-25-2014 05:27 AM
SELECT d.*
FROM cmis:document AS d JOIN ws:webasset AS wa ON d.cmis:objectId = wa.cmis:objectId
WHERE d.cmis:objectTypeId='D:ws:article' AND in_tree(d, '${section:.}')
ORDER BY wa.ws:publishedTime DESC
06-25-2014 11:05 AM
SELECT d.* FROM cmis:document d JOIN ws:webasset w ON w.cmis:objectId = d.cmis:objectId
WHERE
(d.cmis:name = 'name1' OR d.cmis:name = 'name2.html')
AND
(in_folder('${section:/root/folder1}') OR in_folder('${section:/root/folder2}'))
06-25-2014 11:26 AM
06-25-2014 11:45 AM
Tags
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.