topic Re: How to search customized metadata of documents in Alfresco Forum

How to search customized metadata of documents

brucezhou — Wed, 03 May 2017 10:10:06 GMT

Hello expert! I create a customized type called da_record,and add a customized attribute like "da:archival_id",how to search da:archival_id and sort by it by cmis through rest api? The query statement is： SELECT * FROM da:da_record order by da:archival_id . the error is: Ordering is not s

Re: How to search customized metadata of documents

douglascrp — Wed, 03 May 2017 19:26:08 GMT

It will help if you post your custom content model here.

Maybe there is something wrong with it.

You haven't even said the type of that property.

Re: How to search customized metadata of documents

brucezhou — Thu, 04 May 2017 05:39:53 GMT

thank you for you reply,this is my custom model.

Re: How to search customized metadata of documents

douglascrp — Thu, 04 May 2017 11:42:25 GMT

Well, I don't know Japanese (not even sure if that is the right language), but it seems your model is ok.

Can you please translate the columns header's texto into English?

I do not use the model manager, so I do not remember what exactly those columns are.

Re: How to search customized metadata of documents

brucezhou — Fri, 05 May 2017 05:17:50 GMT

hello,

属性：attribute,

显示标签：display label

数据类型：attribute type

要求：is required?

默认值：default value

多值：is Multiple value.

it seems your model is ok. how to order by the customized metadata?

Re: How to search customized metadata of documents

douglascrp — Fri, 05 May 2017 14:28:13 GMT

Is the property you are using in the order by clause a single valued property?

You can not order by multi-valued properties.

Re: How to search customized metadata of documents

brucezhou — Sat, 06 May 2017 04:51:40 GMT

The property using in the order by is single value,but the property type is d:text. The Datetime property can use in the order by.why the custom property in d:text type can't use in the order by?