Print

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

[darichman]

I'm trying to use the combine expression to link two list fields I use for Genre, for use in a pane (ie so the values from both fields appear in the one pane).
The two fields I want to join are [Genres] and [Album Genre] (both list-type)

The expression language page on the wiki describes the correct format as:

Code: [Select]

listcombine([keywords],[people])
so I tried:

Code: [Select]

listcombine([Album Genre],[Genres])
It works fine when you just paste it into an existing field, but I can't seem to get it to work properly as an expression in the panes (see the image attached to see what I mean).

I also tried the

Code: [Select]

&DataType=[List] modifier...

Any ideas? Or is there maybe a better way to do this?

[marko]

Merry Christmas D'man...

To use in an expression pane, you'll need a preceding '=' sign, like so:

Code: [Select]

=listcombine([album genre],[genres])&datatype=[list]
-marko

[darichman]

Marko, that one has been bothering me for ages Thanks - that's exactly what I want.

Eeep it's only half an hour til Christmas Day here... I think it's bed time now.

A very merry Christmas to you too, Marko - is it a white Christmas for you this year?

[marko]

It is indeed... loadsa snow!! The most we've had in years, and the coldest for a while too, -9° C when I left work at 06:30 this morning!! Brrrr.

Last weekend, I took this picture of Edinburgh Castle in the snow as seen from Princes Street Gardens....



Shedloads of snow came down yesterday closing many roads, all schools (WooHoo!! remember that?), the airport, railways... Great fun!!

Then you turn on the local TV news and see which roving reporter is currently out of favour and been sent to some godforsaken part of the country, in the driving snow to film a piece telling us all it's erm, snowing!! Again, great fun!!

Forecast is for light snow late on in the afternoon on Christmas Day. If it comes, I will take my three granddaughters out to build a snowman... we will get wet, and very cold, and the tips of our fingers and toes will hurt, but we will have fun.



-marko

[darichman]

Oh wow... that just sounds completely out of this world to me. We don't get much in the way of snow down my way. In fact, schools get closed if the temperature gets above 41 deg C

Best wishes to you and the family, and thanks again for your help.

PS - We're off to the beach after lunch

[gappie]

for me it is still a bit unclear what the advantage of the listcombine function is.
would: [album genre];[genres]&datatype=

not work also. or at least that is how i do that. so im curious what the difference would be.
ill test maybe later.
guess it will omit the extra ; when one of the values is empty.

 
gab