INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Help with expressions (List)  (Read 3252 times)

221bBS

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 703
Help with expressions (List)
« on: December 05, 2009, 05:22:19 pm »

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]
Logged

gappie

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 4580
Re: Help with expressions (List)
« Reply #1 on: December 05, 2009, 06:15:48 pm »

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
Logged

221bBS

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 703
Re: Help with expressions (List)
« Reply #2 on: December 05, 2009, 06:28:00 pm »

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

gappie

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 4580
Re: Help with expressions (List)
« Reply #3 on: December 05, 2009, 06:35:37 pm »

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?
Logged

gappie

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 4580
Re: Help with expressions (List)
« Reply #4 on: December 05, 2009, 06:46:46 pm »

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

 :)
gab
Logged

221bBS

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 703
Re: Help with expressions (List)
« Reply #5 on: December 05, 2009, 07:17:51 pm »

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

 :)
gab

yes
Logged

221bBS

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 703
Re: Help with expressions (List)
« Reply #6 on: December 05, 2009, 07:50:33 pm »

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
Logged

gappie

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 4580
Re: Help with expressions (List)
« Reply #7 on: December 06, 2009, 05:41:37 am »


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
Logged

221bBS

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 703
Re: Help with expressions (List)
« Reply #8 on: December 06, 2009, 06:19:40 am »

Running 106.

Thanks for trying to help me.
Logged

gappie

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 4580
Re: Help with expressions (List)
« Reply #9 on: December 06, 2009, 07:38:38 am »

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
Logged

221bBS

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 703
Re: Help with expressions (List)
« Reply #10 on: December 06, 2009, 07:58:28 am »

THANK YOU!!!
Logged
Pages: [1]   Go Up