java - Create Facets based on generic data model in Hibernate Search -
our task implement application uses faceted search on hibernate search 4.6. our database model unfortunately mix of relational , generic tables , not possible change that.
this simplified diagram of our model. our index based on entity of data stored key/value pairs in other 2 tables. key in table propertytype while value in table entityproperty.

this leads these fields in index:
entityname entityproperties.propertyvalue entityproperties.propertytypes.propertyname the field propertyname contain facet name while propertyvalue contains different possibilities. problem association between propertyname , propertyvalue lost.
we considered move properties interested in faceting entity table not possible many of our entityproperties. stuck here , suggestion how solve issue highly appreciated.
Comments
Post a Comment