INTERACT FORUM

More => Old Versions => JRiver Media Center 18 for Windows => Topic started by: DanielBMe on December 08, 2012, 01:01:25 pm

Title: Need help with building a calculated field
Post by: DanielBMe on December 08, 2012, 01:01:25 pm

I would like a title in Theaterview in the movie details screen to indicate if the movie is "DVD" or "Blu Ray".  Right now I see "IFO" or "BDMV".  How do I create a new field called Video that uses an expression along the lines of
If File Type = "BDMV" then "Blu Ray" else "DVD"

Title: Re: Need help with building a calculated field
Post by: MrC on December 08, 2012, 01:06:23 pm

The expression :

ifelse(
  isequal([Media Type], Audio), CD,
  isequal([File Type], bdmv), Bluray,
  isequal([File Type], ifo), DVD,
  1, other
)

will give you CD, Blueray, DVD, or other.  Strip out the lines you don't care about.

This can be placed either directly in Theater View as an expression category, or you could create your own field and reference that.