topic Re: [HELP]Retrieve extended properties in Alfresco Archive

[HELP]Retrieve extended properties

jayxm1106 — Wed, 13 Oct 2010 03:13:11 GMT

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:

Re: [HELP]Retrieve extended properties

jayxm1106 — Wed, 13 Oct 2010 08:09:30 GMT

Anyone, Help, Please.

Re: [HELP]Retrieve extended properties

talija83 — Thu, 14 Oct 2010 14:25:14 GMT

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

Re: [HELP]Retrieve extended properties

jayxm1106 — Fri, 15 Oct 2010 02:21:35 GMT

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?

Re: [HELP]Retrieve extended properties

andy — Fri, 15 Oct 2010 14:17:01 GMT

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

Re: [HELP]Retrieve extended properties

jayxm1106 — Thu, 11 Nov 2010 14:58:15 GMT

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.