troubles with checking subfolder ID

[foxtrot1213]

Hi,
here is my query. Obviously, I am mistake somewhere. Basially, I am trying to check whether folder exists or not (the name of folder is in a variable)

"<cmis:query xmlns:cmis=\"http://docs.oasis-open.org/ns/cmis/core/200908/\">
<cmis:statement>SELECT cmisbjectId FROM cmis:folder "+result.html_dirname+"WHERE IN_TREE("+result.html_dirname+",'workspace://SpacesStore/"+globalMap.get("translation.id")+"')</cmis:statement>
<cmis:searchAllVersions>true</cmis:searchAllVersions>
        <cmis:includeAllowableActions>false</cmis:includeAllowableActions>
        <cmis:includeRelationships>none</cmis:includeRelationships>
        <cmis:renditionFilter>*</cmis:renditionFilter>
<cmis:maxItems>50</cmis:maxItems>
<cmis:skipCount>0</cmis:skipCount>
</cmis:query>"

Any help?

[foxtrot1213]

anyone?

[fmui]

If you have the id of the folder it is more efficient to call getObject() and check for an ObjectNotFoundException.
If you only have the name of the folder, then there is "cmis:name = 'somename'" part missing in the WHERE clause.

Is there an error message or does just not return what you are expecting?


- Florian

[foxtrot1213]

I solved it:

"<cmis:query xmlns:cmis=\"http://docs.oasis-open.org/ns/cmis/core/200908/\">
<cmis:statement>SELECT cmisbjectId FROM cmis:folder WHERE cmis:name LIKE '"+DeNor.SubFolder+"' AND cmisarentId LIKE 'workspace://SpacesStore/"+globalMap.get("translation_id")+"'</cmis:statement>
<cmis:searchAllVersions>true</cmis:searchAllVersions>
        <cmis:includeAllowableActions>false</cmis:includeAllowableActions>
        <cmis:includeRelationships>none</cmis:includeRelationships>
        <cmis:renditionFilter>*</cmis:renditionFilter>
<cmis:maxItems>50</cmis:maxItems>

I am using talend ETL to check for documents and folders existance. If not present then create them, if present the upload new content or update existing content.