INTERACT FORUM

More => Old Versions => JRiver Media Center 19 for Windows => Topic started by: Gatherum on May 09, 2014, 01:45:11 am

Title: [19.0.131] Custom sorting
Post by: Gatherum on May 09, 2014, 01:45:11 am

Is there a way to sort by a given library field in any order other than ascending or descending, particularly a custom order á la playlists? In my video section, I am currently sorting with [Media Sub Type] at the top level in descending order. What I want to do is define a custom order: TV Show, Movie, Short. Right now, it is Short, TV Show, Movie.

What do?

Title: Re: [19.0.131] Custom sorting
Post by: MrC on May 09, 2014, 02:16:02 am

Yes.  I'll show you how tomorrow.

Title: Re: [19.0.131] Custom sorting
Post by: Gatherum on May 09, 2014, 02:33:15 am

Okay. Thanks. :)

Title: Re: [19.0.131] Custom sorting
Post by: MrC on May 09, 2014, 10:15:47 am

Here's how you do it.

Since sorting is ASCII-betical, you need to create an expression that converts Media Sub Type values into a values that will sort the way you want.  You said you wanted:

   TV Show
   Movie
   Short

So let's assign them this way:

   1=TV Show
   2=Movie
   3=Short
   ...

and with that, we can use an expression to pull out the numerical values, which will sort the way we want:

   if(regex(1=TV Show; 2=Movie; 3=Short;, /#(\d+)=#/[media sub type];\s*), [R1], 100)

What we've done above is to create sort string, and pulled out only the part that matches the media sub type, along with its accompanying sort index.  For any MST you have not defined in the string, the sort value of 100 will be returned.  You can add additional values to the string above - the pattern should be obvious: #=<mst value>; and the trailing ; is important.

Create a new user field, of type expression and enter that expression as the Calculated data.  Name the expression something like _sort_MST.

Now you need to create a custom sort preset.  In any Standard View, go to the tab's pulldown, and select Sort By > Custom, and click the Add button.  From the a-z sort items, select your new field _sort_MST, and then save it as a Preset by clicking the Preset button.  Call it something like Media Sub Type (custom sort).  Once you have that saved, you can now use it instead of the limited Ascending, Descending, ... pre-defined sorts in the Category > Settings > Sorting pulldown.

You can work out your sort order in an expression column adjacent to a Media Sub Type column.  See attached.

Title: Re:
Post by: nitephlight on May 10, 2014, 12:53:31 am

bookmarked- your wisdom will come handy one day surely

Title: Re: [19.0.131] Custom sorting
Post by: Gatherum on May 10, 2014, 06:14:11 am

That worked perfectly! Thank you! :D