Google translate: How to filter multilingual data in a database?

[Rodien]

Hi guys,

I am writing a query to retrieve the 'News' data, which is multilingual. Currently, I am retrieving data but I am not getting the default language, so I would like to filter it to get data in a different language.

I assume there must be a language key somewhere in the database tables, but I cannot find it.

Therefore, at the moment, I am returning the following data, but I want to retrieve it in a specific language.

I want to use the query inside DNN Sharp searchboost, which is the reason why I am doing this.

@tvatavuk @iJungleboy

[iJungleboy]

Hi @Rodien

The SQL structure is fairly difficult to work with. Especially with multi-language.

If there is any way to provide data to SearchBoost using a C# API I would recommend that. For example, IMHO SearchBoost support the standard Dnn ISearchable interface which 2sxc supports as well - you can even customize what it does. I would highly recommend you use that instead.

The Sql method is challenging. Basically you have

1. Entities
2. Attributes
3. Values - connected to Dimensions - which are an ID referencing a language...

[Rodien]

Oh okay, I am going to take a look and try a few things.