On 5/2/2018 2:56 PM, Weffelmeyer, Stacie wrote: > Question on faceting. We have a dynamicField that we want to facet > on. Below is the field and the type of information that field generates. > > > > cid:image001.png@01D3E22D.DE028870 >
This image is not available. This mailing list will almost always strip attachments from email that it receives. > > "*customMetadata*":["{\"controlledContent\":{\"metadata\":{\"programs\":[\"program1\"],\"departments\":[\"department1\"],\"locations\":[\"location1\"],\"functions\":[\"function1\"],\"customTags\":[\"customTag1\",\"customTag2\"],\"corporate\":false,\"redline\":false},\"who\":{\"lastUpdateDate\":\"2018-04-26T14:35:02.268Z\",\"creationDate\":\"2018-04-26T14:35:01.445Z\",\"createdBy\":38853},\"clientOwners\":[38853],\"clientLastUpdateDate\":\"2018-04-25T21:15:06.000Z\",\"clientCreationDate\":\"2018-04-25T20:58:34.000Z\",\"clientContentId\":\"DOC-8030\",\"type\":{\"applicationId\":2574,\"code\":\"WI\",\"name\":\"Work > Instruction\",\"id\":\"5ac3d4d111570f0047a8ceb9\"},\"status\":\"active\",\"version\":1}}"], > I do not know what this is. It looks a little like JSON. But if it's json, there are a lot of escaped quotes in it, and I don't really know what I'm looking at. > > > It will always have customMetadata.controlledContent.metadata > > > > Then from metadata, it could be anything, which is why it is a > dynamicField. > > > > In this example there is > > customMetadata.controlledContent.metadata.programs > > customMetadata.controlledContent.metadata.departments > > customMetadata.controlledContent.metadata.locations > Solr does not have the concept of a nested data type. So how are you getting from all that text above to period-delimited strings in a hierarchy? If you're using some kind of custom plugin for Solr to have it support something it doesn't do out of the box, you're probably going to need to talk to the author of that plugin. Solr's dynamicField support is only dynamic in the sense that the precise field name is not found in the schema. The field name is dynamic. When it comes to what's IN the field, it doesn't matter whether it's a dynamic field or not. > If I enable faceting, it will do so with the field customMetadata. But > it doesn’t help because it separates every space as a term. But > ideally I want to facet on customMetadata.controlledContent.metadata. > Doing so brings back no facets. > > > > Is this possible? How can we best accomplish this? > We will need to understand exactly what you are indexing, what's in your schema, the exact query requests you are sending, and what you are expecting back. Thanks, Shawn