I have categories facets. Currently on in 1 language, but since my site is
multilanguage, I need to index them in multiple languages.

My table looks like this:

[music_categories]
id      int     Unchecked
title   nvarchar(50)    Unchecked
title_en        nvarchar(50)    Unchecked
title_nl        nvarchar(50)    Unchecked




In my data-config.xml I have this, only for 1 language:

<entity name="artist_category" query="select categoryid from
artist_categories where objectid=${artist.id}">
        <entity name="category" query="select title from music_categories where 
id
= '${artist_category.categoryid}'">
                <field name="categories" column="title"  />
        </entity>
</entity>


Now, the only way I can imagine indexing multiple languages is by
duplicating these lines:

<entity name="artist_category_en" query="select categoryid from
artist_categories where objectid=${artist.id}">
        <entity name="category_en" query="select title_en from music_categories
where id = '${artist_category.categoryid}'">
                <field name="categories_en" column="title_en"  />
        </entity>
</entity>

<entity name="artist_category_nl" query="select categoryid from
artist_categories where objectid=${artist.id}">
        <entity name="category_nl" query="select title_nl from music_categories
where id = '${artist_category.categoryid}'">
                <field name="categories_nl" column="title_nl"  />
        </entity>
</entity>


Is there a better way, e.g. where I can do some sort of parametering like
{lang] or something?

--
View this message in context: 
http://lucene.472066.n3.nabble.com/Indexing-multiple-languages-tp2891546p2891546.html
Sent from the Solr - User mailing list archive at Nabble.com.

Reply via email to