C# plugin: How to sort episode items with specials?

[pünktchen 1350]

How i can sort episode items so that specials are listed between regular episodes?

[pünktchen 1350]

Nobody? @Luke

[Luke 40077]

Hi, where are you calling from, a plugin, or the api?

Are you pulling down episodes from a single series or all episodes from the library?

[pünktchen 1350]

1 hour ago, Luke said:

Hi, where are you calling from, a plugin, or the api?

Plugin.

1 hour ago, Luke said:

Are you pulling down episodes from a single series or all episodes from the library?

Multiple series but not necessary all.

var sortedEpisodeList = unsortedEpisodeList.OrderBy(e => e.DisplayParent.DisplayParent.Name).ThenBy(e => e.ParentIndexNumber).ThenBy(e => e.IndexNumber).ToList();

 

[Luke 40077]

OK, in your query to get the episodes from the series, just don't explicitly specify a sort order in your query and then you'll get the correct order.

[pünktchen 1350]

There's no way to do it afterwards? I'm doing several other things with the output of the initial query which in turn results in an unsorted list of episodes.

[Luke 40077]

We do this with a database query, not managed c#. So yes you can recreate it, but there isn't a ready made method you can call. 

Try this for starters, off the top of my head:

            new List<Episode>()
                .OrderBy(i => i.SortParentIndexNumber ?? i.ParentIndexNumber)
                .ThenBy(i => i.SortIndexNumber ?? i.IndexNumber)
                .ThenBy(i => i.PremiereDate)
                .ThenBy(i => i.SortName)

That should be a close enough starting point.