INTERACT FORUM

More => Old Versions => JRiver Media Center 25 for Windows => Topic started by: arcspin on September 29, 2019, 05:04:36 am

Title: Need help to Group movies by runtime
Post by: arcspin on September 29, 2019, 05:04:36 am

Hi all,
We had some friends over last night and I got the chance to show the JRiver Theater view for our friends.
One thing that we come to discuss is that sometimes it would be nice to be able to group movies by runtime. For example yesterday we were looking for a movie that were around two hours long to watch.

Soooo, I need some help creating an expression in Theater view.
This is what I would like to sort my movies by: Duration of the movie, aka Runtime

I would like to sort my movies into these runtime groups.

----> up to 1h30m
1h31m - 1h50m
1h51m - 2h10m
2h11m - 2h30m
2h31m - 2h50m
2h51m - 3h10m
3h11m ---->


Can someone please help me out creating this expression?




Greatly appreciate any help,
//arcspin

Title: Re: Need help to Group movies by runtime
Post by: Moe on September 29, 2019, 10:21:11 am

https://yabb.jriver.com/interact/index.php/topic,107001.msg743344.html#msg743344

You’ll have to tweak it to get the groups you want. But it should be obvious how to do so once you see the expression.

Title: Re: Need help to Group movies by runtime
Post by: arcspin on September 29, 2019, 12:04:31 pm

Thank you Moe for the help.
I will most certainly look into this and make my own tweaks.

Cheers,

//arcspin

Title: Re: Need help to Group movies by runtime
Post by: Moe on September 29, 2019, 02:13:17 pm

I was without power when I posted earlier.

FYI, this was the final expression that I ended up using.

ifelse(isrange([duration,0],1-1800),Less Than 30:00,
            isrange([duration,0],1800-2700),30:00 - 45:00,
            isrange([duration,0],2700-3600),45:00 - 60:00,
            isrange([duration,0],3600-4500),1:00:00 - 1:15:00,
            isrange([duration,0],4500-5400),1:15:00 - 1:30:00,
            isrange([duration,0],5400-6300),1:30:00 - 1:45:00,
            isrange([duration,0],6300-7200),1:45:00 - 2:00:00,
            isrange([duration,0],7200-8100),2:00:00 - 2:15:00,
            isrange([duration,0],8100-9000),2:15:00 - 2:30:00,
            isrange([duration,0],9000-9900),2:30:00 - 2:45:00,
            isrange([duration,0],9900-10800),2:45:00 - 3:00:00,
            1,3:00:00+)

Title: Re: Need help to Group movies by runtime
Post by: arcspin on September 29, 2019, 03:15:21 pm

Thank you Moe,
I ended up with these groups:

Code: [Select]

ifelse(isrange([duration,0],1-3600),0:00 - 60:00,
            isrange([duration,0],3600-5400),1:00 - 1:30,
            isrange([duration,0],5400-6600),1:30 - 1:50,
            isrange([duration,0],6600-7800),1:50 - 2:10,
            isrange([duration,0],7800-9000),2:10 - 2:30,
            isrange([duration,0],9000-10200),2:30 - 2:50,
            isrange([duration,0],10200-11400),2:50 - 3:10,
            1,3:10+)
I will try out some more variants to see what I like but for now this is just great.


Again, much appreciate the support,

//arcspin