topic CMIS query, cmis:path in WHERE clause in Alfresco Archive

CMIS query, cmis:path in WHERE clause

http — Thu, 05 Apr 2012 09:06:39 GMT

Hi all,I'm using the CMIS query language. A basic query like SELECT * FROM cmis:folder WHERE cmis:name='dataLists'‍ works fine.However, when querying the cmisath property, I get an Internal Server error.SELECT * FROM cmis:folder WHERE cmisath='dataLists'‍I expect the above query to return 0 resu

Re: CMIS query, cmis:path in WHERE clause

mitpatoliya — Thu, 05 Apr 2012 10:01:06 GMT

that is because in that query with WHERE clause you can only use the queryable properties.Where cmisath is not one of those property.

Re: CMIS query, cmis:path in WHERE clause

http — Thu, 05 Apr 2012 18:14:39 GMT

thanks for pointing this out. i've overlooked this in the documentation: http://wiki.alfresco.com/wiki/CMIS_Query_Language#cmis:folder

is there a way to query cmisath using CONTAINS() ?

Re: CMIS query, cmis:path in WHERE clause

andy — Tue, 10 Apr 2012 09:24:16 GMT

Hi

You can use the standard Alfrecso path ueing

….CONTAINS('PATH:"//."')

Andy

Re: CMIS query, cmis:path in WHERE clause

http — Wed, 11 Apr 2012 12:42:44 GMT

Hi Andy,

a query for CONTAINS('PATH:"//."') returns all repository items, indeed.
how do I query for the repository item with a certain path, say /Sites/mysite/documentLibrary/MyFolder ?

as far as i can understand the documentation, the PATH queries are for querying the type of objects (as opposed to their cmisath property) http://wiki.alfresco.com/wiki/Search#Path_Queries

thanks,
gabor

Re: CMIS query, cmis:path in WHERE clause

mitpatoliya — Mon, 16 Apr 2012 04:59:47 GMT

No, I think you get it wrong.
Path Queries are to narrow down the search at particular location.
You can get all the documents residing under particular path using path query.

Generally this path query is user along with other property based query and aspect based query.
Hope this is clear now.

Re: CMIS query, cmis:path in WHERE clause

http — Tue, 17 Apr 2012 07:02:14 GMT

I was not able to narrow down the search by path.
Looking for all folders within MyFolder with the path /Sites/mysite/documentLibrary/MyFolder.

SELECT * FROM cmis:folder WHERE CONTAINS('PATH:"/Sites/mysite/documentLibrary/MyFolder"')‍

The above query returns no results.
Probably I'm getting the syntax within the CONTAINS predicate wrong.

How do I query for folders located below a certain path?

Would I have the the objectId of MyFolder, I could use IN_FOLDER or IN_TREE predicates. However, I have to query based on path.

thanks in advance,
gabor

Re: CMIS query, cmis:path in WHERE clause

andy — Tue, 17 Apr 2012 16:06:51 GMT

Hi

You can use the node browser in share to get the PATH. It will be something like:

/app:company_home/st:sites/cm:swsdp/cm:documentLibrary/cmresentations

with ISO 9075 escaping as required for the path elements

Andy

Re: CMIS query, cmis:path in WHERE clause

johnny_k — Wed, 30 Jul 2014 14:06:46 GMT

Hello Andy
Can u tell me how i can get all folder from site
and other query all files in folder
i am trying use somethink like SELECT * FROM cmis:folder WHERE CONTAINS('PATH:"/Sites/mysite/documentLibrary/MyFolder"')
but i get only empty table

Re: CMIS query, cmis:path in WHERE clause

johnny_k — Thu, 31 Jul 2014 11:36:54 GMT

SELECT * FROM cmis:folder WHERE CONTAINS('PATH:"//app:company_home/st:sites/cm:NameSite/cm:documentLibrary/*"')

Solution of my question =))