[HELP]Retrieve extended properties

[jayxm1106]

Hi there,

I want to retrieve extended properties in specified folder through CMIS.

First ,

select * from cmis:document where IN_FOLDER('"+ objectFolderId +"')  ‍

is OK.

But When i use join condition,  IN_FOLDER can't work.
Here is my code.
      

   sql = " select d.*, t.* " +
               "   from cmis:document  as d " +
               "   join cm:titled      as t on d.cmis:objectId = t.cmis:objectId" +
               " where IN_FOLDER('"+ objectFolderId +"') ";‍‍‍‍

Could anyone help me to correct that?
Thanks!

[jayxm1106]

Anyone, Help, Please.

[talija83]

Maybe the object in question doesn't have an cm:titled aspect?  :?:

[jayxm1106]

Maybe the object in question doesn't have an cm:titled aspect?  :?:

Hi,talija83, thanks for your reply.

But i can get the right result by

   sql = " select d.*, t.* " +
               "   from cmis:document  as d " +
               "   join cm:titled      as t on d.cmis:objectId = t.cmis:objectId"‍‍‍

and

select * from cmis:document where IN_FOLDER('"+ objectFolderId +"') ‍

but failed query the data if i use the CMIS SQL below:

   sql = " select d.*, t.* " +
               "   from cmis:document  as d " +
               "   join cm:titled      as t on d.cmis:objectId = t.cmis:objectId" +
               " where IN_FOLDER('"+ objectFolderId +"') ";‍‍‍‍

How to let IN_FOLDER work?

[andy]

Hi

To use IN_FOLDER with join you have to specify the qualifier.
It needs to know where to apply the constraint.

You use the alias for the table in the IN_FOLDER

SELECT D.*, O.* FROM CMISOCUMENT AS D JOIN CMWNABLE AS O ON D.cmisbjectId = O.cmisbjectId WHERE IN_FOLDER(D, 'SOME_ID')

Andy

[jayxm1106]

Hi

To use IN_FOLDER with join you have to specify the qualifier.
It needs to know where to apply the constraint.

You use the alias for the table in the IN_FOLDER

SELECT D.*, O.* FROM CMISOCUMENT AS D JOIN CMWNABLE AS O ON D.cmisbjectId = O.cmisbjectId WHERE IN_FOLDER(D, 'SOME_ID')

Andy

Yeah，It's work. Thanks a lot and sorry for my late reply.