Is it possible to query WCM content through web-script

meetkenepps — Sun, 17 Aug 2008 09:16:30 GMT

I have been reading about the WCM capabilities of Alfresco and the web scripts framework. One thing, that is not very clear to me so far is whether it is possible to query the content created using WCM webforms through web-scripts. I think that it should be; but I am not 100% sure. Similar question:

Re: Is it possible to query WCM content through web-script

pmonks — Sun, 17 Aug 2008 15:22:26 GMT

Your hunch is spot on - it is indeed possible to query WCM content (including both Web Form backed and "static" files) via Web Scripts. For Javascript-backed Web Scripts, you can use the AVM JS API (http://wiki.alfresco.com/wiki/JavaScript_API#AVM_API), while for Java-backed Web Scripts you'd use the AVMService Java API (http://dev.alfresco.com/resource/docs/java/repository/org/alfresco/service/cmr/avm/AVMService.html).

As for querying for specific types, I can think of two ways to do that (this is off the top of my head - there may be more approaches as well):

The first is to query for the "parentformname" attribute (a property which is automatically populated by the WCM system). For example the Lucene query
```
TEXT:"Alfresco" AND @\{http\://www.alfresco.org/model/wcmappmodel/1.0\}parentformname:'Product Data-Sheet"‍
```
would search for all product data-sheets containing the word "Alfresco" somewhere in the full text.

Use XML Metadata Extraction (http://wiki.alfresco.com/wiki/Metadata_Extraction#XML_Meta-data_Extractor_Configuration_for_WCM) to index a custom property with the name of the type.

Although it's more work, the second approach supports more complex use cases, such as the case where you want to treat multiple different Web Form types as if they were a single type at querying time (of course you could also use approach #1 with a set of "ORs", but that likely won't perform as well a single query clause against a custom property).

Cheers,
Peter

Re: Is it possible to query WCM content through web-script

meetkenepps — Sun, 17 Aug 2008 17:13:51 GMT

Thanks Peter, this is real good start for me.

-Ken

topic Re: Is it possible to query WCM content through web-script in Alfresco Archive

Is it possible to query WCM content through web-script

Re: Is it possible to query WCM content through web-script

Re: Is it possible to query WCM content through web-script