Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[zxsix]

I am using the Collection field to group movies.
All Avengers movies are tagged with:
Collection = Avengers
and then others have a secondary collection tag:
Collection = Avengers; Iron Man
Collection = Avengers; Thor
Collection = Avengers; Captain America
Collection = Avengers; Ant-Man
Collection = Avengers; Spiderman

Under Theater View settings > Items to Show
is this expression:

Code: [Select]

<font size="65">if(isempty([Collection, 1]), [Name],
<font color="FF0000">Fixcase(listitem([Collection],0),3) COLLECTION)
if(isempty(listitem([Collection],1)),  ,
Fixcase(listitem([Collection],1),3) COLLECTION<//font>)

If I view the Avengers group, It contains only the movies with the single Collection value of Avengers.
It excludes the movies that have a second value in the Collection field such as Thor.
I'm sure this has to do with the listitem feature, since that's selecting only one of the values.

The preferred result would be for all of the movies to show up in the Avengers grouping, and then also show up in the smaller secondary grouping.