topic Querying Custom MetaData in Alfresco Archive

Querying Custom MetaData

dallinns — Mon, 14 Mar 2011 19:28:16 GMT

I have a custom type in Alfresco, for the time being it is "sc:mine". Each document of this type has a section property (sc:section). I have several documents that have "ENGL316001" specified as their value for the property sc:section. I want to do a query search to find all documents whose sc:secti

Re: Querying Custom MetaData

rmcveigh — Mon, 14 Mar 2011 19:41:29 GMT

Without trying this myself why not do:

select * from sc:mine where sc:section = 'ENGL316001'‍

-Ryan

Re: Querying Custom MetaData

dallinns — Mon, 14 Mar 2011 21:03:33 GMT

That actually worked, thanks. I guess I was making it too complicated.

Re: Querying Custom MetaData

rmcveigh — Mon, 14 Mar 2011 21:40:25 GMT

Sure thing, glad I could help.

Generally if you look at a type's details from CMIS you'll see querynames and other interesting metadata. I believe Alfresco returns query names to match the actual property names in your model, but this isn't guaranteed by the CMIS spec, so you'll want to interrogate the API to get query names. Similarly you can get information like if a property can be used in an order by statement by checking the orderable field.

-Ryan