topic Re: How are Associations stored in Solr? in Alfresco Archive

How are Associations stored in Solr?

jmalmeida — Tue, 22 Nov 2016 16:46:08 GMT

Main question:Within Alfresco we have the possibility to create connexions between documents through the associations (see Associations | Alfresco Documentation). I am investigating if it is possible to search for a given document based on the metadata of it's associations. For that I would like to

Re: How are Associations stored in Solr?

kaynezhang — Wed, 23 Nov 2016 01:50:06 GMT

1.Alfresco only save parent-children association information in solr ,solr fiels named like PRIMARYPARENT/PARENT are used to save parent-children association information.
2.Regular node associations are not saved in solr ,they are only saved in db.

3.Alfresco solr index every node as a document and solr nested document is not used in alfresco solr.

4.As your requirement ,I think you can create an type which is used as an association purpose,and use cmis join query feature.

Re: How are Associations stored in Solr?

jmalmeida — Wed, 23 Nov 2016 09:04:16 GMT

Thank you for your answer.

The problem is that I would like to use Solr for the search and not CMIS.

From what you are telling me there is no way to index documents as nested in Solr and query them with the Block join queries, without significantly modifying Alfresco indexer, right?

Re: How are Associations stored in Solr?

kaynezhang — Wed, 23 Nov 2016 11:08:50 GMT

Yes

Re: How are Associations stored in Solr?

idwright — Thu, 24 Nov 2016 09:26:37 GMT

It's a bit of a hack but what you can do is to create an aspect that holds the properties of the associated document and then use behaviours to ensure that the aspects are applied and properties are kept consistent.

Then you can use search as you'll have all the properties on the same doc.

Re: How are Associations stored in Solr?

jmalmeida — Fri, 25 Nov 2016 07:51:31 GMT

Thank you.

The problem is that I would have many documents with the same property fields associated and, from my understanding, there cannot be more than one instance of an aspect per document.