How to search customized metadata of documents

cancel
Showing results for 
Search instead for 
Did you mean: 
brucezhou
Active Member

How to search customized metadata of documents

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 support for da:archival_id

6 Replies
douglascrp
Advanced II

Re: How to search customized metadata of documents

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.

brucezhou
Active Member

Re: How to search customized metadata of documents

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

douglascrp
Advanced II

Re: How to search customized metadata of documents

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.

brucezhou
Active Member

Re: How to search customized metadata of documents

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?

douglascrp
Advanced II

Re: How to search customized metadata of documents

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

You can not order by multi-valued properties.

brucezhou
Active Member

Re: How to search customized metadata of documents

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?