topic Re: How do I find all the documents with multiple values in a property? in Alfresco Forum

How do I find all the documents with multiple values in a property?

xkahn — Mon, 20 Nov 2017 20:59:50 GMT

I have a property which can have multiple values, but it typically only has one value. It is defined as: <property name="scroductName"> <title>Products</title> <type>d:text</type> <mandatory>false</mandatory> <

Re: How do I find all the documents with multiple values in a property?

afaust — Mon, 20 Nov 2017 22:24:03 GMT

There is no query variant via default Alfresco Java APIs or any of the search languages for this particular use case.

Re: How do I find all the documents with multiple values in a property?

resplin — Tue, 21 Nov 2017 00:39:04 GMT

Axel Faust‌ is usually correct about these things. I will ask around to see if we have a recommendation for this query.

It would help me to better understand the context around this requirement. What causes you to need to do this?

Re: How do I find all the documents with multiple values in a property?

xkahn — Tue, 21 Nov 2017 03:10:56 GMT

I suspect you are right. I'd be happy to use Solr directly if it supported the query.

I guess the best solution is to find all the documents with the property set at all... And then iterate through the results to find the documents I need.

Re: How do I find all the documents with multiple values in a property?

xkahn — Tue, 21 Nov 2017 03:17:54 GMT

Yeah. I'm trying to align the metadata in two different repositories. This property is split in the other repo. (Singleton value property and then multivariate property if more than one value is needed.) I wanted to see how much work this was going to be.

Re: How do I find all the documents with multiple values in a property?

andy1 — Tue, 21 Nov 2017 10:45:19 GMT

The only way you can do that today is with the public API in 5.2.1. This should count the number of titles for each doc.

{
"query": {
    "query": "name:*"
},
"facetFields": {
      "facets": [
         {"field": "DBID", "label": "DBID"}
      ]
    },
"stats": [{
   "field" : "title",
   "label" : "Title"
}],
    "pivots" : [
       {
           "key": "DBID",
           "pivots": [
               {
                   "key": "Title"
               }
               ]
       }
       ]
}

It does not have a way to get rid of counts you do not want.

In earlier versions you could go direct to SOLR and use the JSON facet API where you can expose what would normally be the "having" clause on the aggregate.

It will be a a bit of a pain as you will have to pick the correct field from the real solr schema.

Andy

Re: How do I find all the documents with multiple values in a property?

afaust — Tue, 21 Nov 2017 20:38:12 GMT

Well, if you can do that with the public API you should be able to do it with the Java API as well, right?

Re: How do I find all the documents with multiple values in a property?

andy1 — Wed, 22 Nov 2017 12:04:20 GMT

Yes, you can do it in the Java API as that is how we implement the public API - but again only on 5.2.1.

In general the public API is cleaner. The Java API has a couple of oddities for things like multi-select facets - but these do not matter for this case.
They were a pain to do in a backwards compatible way with the Java API.

Andy