topic Re: The efficient way of finding property-values in Alfresco Archive

The efficient way of finding property-values

buurd — Thu, 11 Mar 2010 08:55:28 GMT

HiI have a script that finds all values used for a particular property. Consider the following function that recives the resultset from a Lucene query and a name of a property (cm:author for example).function getPropertyValues(results, property){ var values = new Array(); for(var i = 0; i <

Re: The efficient way of finding property-values

buurd — Fri, 19 Mar 2010 07:53:09 GMT

Since I have not got any answers here I have now opened a support-ticket. I'll report back when I have an answer.

Re: The efficient way of finding property-values

buurd — Mon, 29 Mar 2010 08:29:01 GMT

I got some feedback from Redpill on the problem. There are a table in the Alfresco-database that I can query:

select distinct string_value from alf_node_properties where qname_id = ?

Now I just need to figure out how to access the database directly, the alfresco way.

//Roland

Re: The efficient way of finding property-values

andy — Tue, 06 Apr 2010 13:57:37 GMT

Hi

The DB is not the way to go … There is no index for the query.

See getTopCategories() in LuceneCategoryServiceImpl which is essentially the same thing.

Andy