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.

databasemodel

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

Popular posts from this blog

php - Invalid Cofiguration - yii\base\InvalidConfigException - Yii2 -

How to show in django cms breadcrumbs full path? -

ruby on rails - npm error: tunneling socket could not be established, cause=connect ETIMEDOUT -