cancel
Showing results for 
Search instead for 
Did you mean: 

Can we create Indexes on relation in Hybris?

Former Member
0 Kudos

There is a requirement for me to create an Index on a relation. Can someone help me out with complete details of creating an Index on a relation.

Former Member
0 Kudos

Depends on the relation type, are you talking about n:m or n:1/1:n?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi, Shyam

If your relation table stores simple types like int or string you can try adding that relation as indexable type in backoffice and see if it is searchable as some relations are seen in backoffice type search results:

1) You need to create new indexed type at backoffice->system-> search and navigation ->Indexed Types.

2) Then add created indexed type to search configuration at Backoffice-> system -> search and navigation - > facet search configuration - > choose indexed shoot -> go to properties tab -> add your type to be indexed.

3a) After testing if your relation works as indexable type. Try to recreate that in impex.

3b) If your property is not of basic types like string etc. You may want to try and create your own “composed type” at shema.xml and add to it value store=true to enable indexing.

In theory you can only add as indexable documents items of types like string, int etc. but you can try creating your own type by extending (Extension) solrserver -> resources -> solrCustomizations->files->server->solr->configsets->backoffice->conf->schema.xml

Best Regards,

Former Member
0 Kudos

Thanks for the solution . Unfortunately, I did not find search and navigation in the System of backoffice. Can you please help me on this. Once the Index is created successfully, is there any way that I can see the newly created Index in the Database as well.

Former Member
0 Kudos

Are we talking right now about indexing relations in database or indexing relationships in Solr?

Whichever it is: 1. Solr index type can be found as "SolrIndexedType". Executing a search for it in HAC returns "forbidden". 2. Relationships in a database can be found with a flexible search, by searching its code name from *-items, but in a real database, those table names are shortened.

"Where are navigation and search?": In older versions, it was under facet search: (example photo at first step of https://help.hybris.com/6.5.0/hcd/8c7867a586691014bacd89c30a0c83d1.html).

Former Member
0 Kudos

Last time I checked on relation tables in database these names were combined from every first letter of every word used in a relation name. But that was in my autogenerated database.