nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

[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!

Find more posts tagged with

Comments

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 CMIS

OCUMENT AS D JOIN CM

WNABLE AS O ON D.cmis

bjectId = O.cmis

bjectId 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.