Content localization within decoupled website #7649

draxtor · 2020-11-15T17:29:14Z

draxtor
Nov 15, 2020

Hello,
I've created decoupled website using Asp.Net Core 3.1
I'm using orchard core nugets:

2 abstraction nugets I've installed out of despair, I don't know what they do I was looking for ILocalizationService which is mentioned on the internet somewhere.

I turned on all localization features and created little component for switching languages (eng and fra for now).
Based on
<html lang="@Orchard.CultureName()">
it looks that it is working fine.
So I started to localize content types. But I cannot found any way of filtering content items based on culture.
I've tried:

  var articles = await _orchard.GetRecentContentItemsByContentTypeAsync("HomeArticles");
  var articles = await _orchard.QueryContentItemsAsync(x=> x.Where(y => y.Published));

but all items for all languages are returned.
There are no overload which I can use to send culture info.

Is there a way to use content localization in decoupled website? Or at least to filet content items based on culture.

Thanks

hishamco · 2020-11-15T17:59:48Z

hishamco
Nov 15, 2020
Maintainer

Try to install Content Localization module if you interested in localizable content items

7 replies

hishamco Nov 15, 2020
Maintainer

After a quick look seems DefaultContentLocalizationManager has some helper method that allow you to achieve that

draxtor Nov 15, 2020
Author

Cool thanks I'll try it.
I have some progress with SQL queries but it is cumbersome to glue the whole object together with SQL query. Alternative is using SQL to get id and then do the helper stuff (with n+1 penalty for fetching).

draxtor Nov 16, 2020
Author

I've tried DefaultContentLocalizationManager but it doesn't fit into my scenario.
It exposes:

      Task<IDictionary<string, ContentItem>> DeduplicateContentItemsAsync(IEnumerable<ContentItem> contentItems);
       Task<ContentItem> GetContentItemAsync(string localizationSet, string culture);
       Task<IDictionary<string, string>> GetFirstItemIdForSetsAsync(IEnumerable<string> localizationSets);
       Task<IEnumerable<ContentItem>> GetItemsForSetAsync(string localizationSet);
       Task<IEnumerable<ContentItem>> GetItemsForSetsAsync(IEnumerable<string> localizationSets, string culture);
       Task<ContentItem> LocalizeAsync(ContentItem content, string targetCulture);

Problem is that localizationSet is required for all of them except for the DeduplicateContentItemsAsync one. I don't have localizationSet at the moment I have ContentType and culture.

On the other hand SQL Query is fine, not sure about performance but I created following query in the admin:

SELECT * FROM 
[ContentItemIndex] 
INNER JOIN [LocalizedContentItemIndex] ON [ContentItemIndex].[ContentItemId] = [LocalizedContentItemIndex].[ContentItemId]
INNER JOIN [Document] ON [ContentItemIndex].[DocumentId] = [Document].[Id] 
WHERE [ContentItemIndex].[ContentType] = @contentType AND [LocalizedContentItemIndex].[Culture] = @lang;

and it's fulfilling my use case.

jptissot Nov 18, 2020
Maintainer

Have a look at what is done in https://github.com/OrchardCMS/OrchardCore/blob/6cddd9f9904ff117ba82587f39fc76f49fac3cc3/src%2FOrchardCore.Modules%2FOrchardCore.ContentLocalization%2FLiquid%2FContentLocalizationFilter.cs

ManOguaR May 24, 2025

            .With<LocalizedContentItemIndex>(x => x.Culture == culture)

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Content localization within decoupled website #7649

Uh oh!

{{title}}

Uh oh!

Replies: 1 comment 7 replies

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Select a reply

Uh oh!

Content localization within decoupled website #7649

Uh oh!

draxtor Nov 15, 2020

Replies: 1 comment · 7 replies

Uh oh!

hishamco Nov 15, 2020 Maintainer

Uh oh!

hishamco Nov 15, 2020 Maintainer

Uh oh!

draxtor Nov 15, 2020 Author

Uh oh!

draxtor Nov 16, 2020 Author

Uh oh!

jptissot Nov 18, 2020 Maintainer

Uh oh!

ManOguaR May 24, 2025

draxtor
Nov 15, 2020

Replies: 1 comment 7 replies

hishamco
Nov 15, 2020
Maintainer

hishamco Nov 15, 2020
Maintainer

draxtor Nov 15, 2020
Author

draxtor Nov 16, 2020
Author

jptissot Nov 18, 2020
Maintainer