cancel
Showing results for 
Search instead for 
Did you mean: 

Cmis 3.2 query issue

youngqi
Champ in-the-making
Champ in-the-making
I upload the aa.jpg file to "sample" folder in my local server, when I query “
SELECT * FROM cmis:document
”, I can get 54 files. when I query “
SELECT * FROM cmis:document where cmis:name <> 'aa.jpg'
”. I get 53 files. But when I query “
SELECT * FROM cmis:document where cmis:name = 'aa.jpg'
”. I cannot get any files? who do know what had happened?

the id of "sample" folder is 'workspace://SpaceStore/3b3fe2c4-c1c3-4409-abfd-3fbb349d3fa'. but when I query
SELECT * FROM cmis:document where IN_FOLDER('workspace://SpaceStore/3b3fe2c4-c1c3-4409-abfd-3fbb349d3fa')
. I cannot get any files.
3 REPLIES 3

gclaussn
Champ in-the-making
Champ in-the-making
hi youngqi,
i got similiar issues, when querying. I think 3.2 is not fully CMIS supported, but i red, that in v3.3 CMIS Query is full implemented.
See http://wiki.alfresco.com/wiki/Alfresco_Community_Edition_3.3#Full_Implementation_of_CMIS_1.0_Specifi...

best regards, gclaussn

alexh
Champ in-the-making
Champ in-the-making
Hi guys,

I have similar problems with the 3.3, I'm not able to get any result if the SQL statement contains any string operations
(WHERE cmis:name = 'mytest'). Is it working for you, with the 3.3?
Are you using CMIS-REST or SOAP services?

I use SOAP and got several additional problems.

Regards
alex

helenk579
Champ in-the-making
Champ in-the-making
hi youngqi,
i got similiar issues, when querying. I think 3.2 is not fully CMIS supported, but i red, that in v3.3 CMIS Query is full implemented.
See http://wiki.alfresco.com/wiki/Alfresco_Community_Edition_3.3#Full_Implementation_of_CMIS_1.0_Specifi...

best regards, gclaussn

Such a very amazing link!
_________________
Watch The Twilight Saga Eclipse Online Free