Print

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

[221bBS]

I'm trying to combine 2 fields into a semicolon delimited field. I'm having some trouble.

I want to create a  pane view using the "Artist" and a custom field call "Artist: Add. (Main)". I've tried various ways using the "&datatype=[list ]", "ListBuild()", "ListItem()" & "ListCombine()" expressions. What ends up happening is the panes lists everything correctly but the list of songs it should list is either from the "Artist" field or "Artist: Add. (Main)" but not both.

Example:

5 tracks from...
Artist: The Supremes
Artist: Add. (Main): Diana Ross

5 tracks from...
Artist: Diana Ross & The Supremes
Artist: Add. (Main): Diana Ross;The Supremes

5 tracks from...
Artist: Diana Ross
Artist: Add. (Main):

In the pane, if I click Diana Ross only 5 tracks show instead of 15. When I slick The Supremes, I end up with no songs at all.


Is there any way to use expressions to make the delimited field work the way it should?[/list]

[gappie]

its a bit of late here, to tired to test, but i like playing around with expressions. what happen when you 'keep it simple' and use some thing like:

Code: [Select]

[artist];[Artist: Add. (Main)]&datatype=[list]in the expression?

 
gab

[221bBS]

The Pane shows the correct artist but no files are shown when I click an artist

[gappie]

strange, i just tried with my artist, and artists field, and it works like you want to. get all the files that are under an artist or artists.
what happens when you leave the artist away from the expression, could it be that the name of the artis: add etc field gievs a problem?

[gappie]

that [artist add etc ] field is a list field isnt it?

 
gab

[221bBS]

that [artist add etc ] field is a list field isnt it?

 
gab

yes

[221bBS]

I thought that ":", ".", "(", ")" might be causing the trouble so I made another field "ArtistTest" but that didn't help.

I tried an expression field "[ArtistTest]&datatype=[ list]" with the data type being string and delimited. And I got the same problem. Both times.

There's no problem as long as only one artist is listed, when I add two or more in the field I get no listing

[gappie]

There's no problem as long as only one artist is listed, when I add two or more in the field I get no listing

that seems to work for me   ? i do remember there where some problems like this in the past though.
you are using a recent 14 version?
actually it should not really make a difference in this case if the data type for artisttest is set to string or list delimited.

 
gab

[221bBS]

Running 106.

Thanks for trying to help me.

[gappie]

got it, i think. are you putting the expression in a calculated field? because then i get the same. i thought you were talking about using the expression in a pane.

if that is the case, there is a solution:
http://yabb.jriver.com/interact/index.php?topic=54226.msg374211#msg374211

in your case, go to the calculated field, and set the field to userdat (disabeling the calcultion), choose as datatype, list. close the library manager and option. now open the library manager again, and set that field again to calculated data.

 
gab

[221bBS]

THANK YOU!!!