Print

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

[ferday]

if i use a list field
and make an expression column if(listcontains([genre],rock),yes,no)
it indeed works

if i use this exact same expression in RMC it does not work.  

if i change the list field to a string field, than the listcontain() expression works

this is exactly the same behaviour with isequal([genre],rock,8),yes,no) and REGEX on a list.

it seems the RMC will not take a list type field for any search expression, it will only evaluate the first member of the list.  

edit: further investigation says that if(listcontains([genre],r),yes,no) in fact works, as long as rock is the first in the list.  so the RMC tool is evaluating the expression differently than an expression column

[glynor]

RMCF does evaluate list type fields differently than other places in MC, on purpose.

A file can have multiple Artists, but can't be in multiple folders. And having a folder called "Artist 1; Artist 2; Artist 3; Artist 4" (and possibly another one that is "Artist 2; Artist 1; Artist 4; Artist 3" and so on and so forth) is not desirable. So, the first result in any List Type field or expression is used by RMCF (kind of considered the primary).

You can add &datatype=string if you want, but be aware of sorting order (you'll also have to sort the list first if you don't want it to make multiple folders like I mentioned above).

[ferday]

thanks mate, that makes sense when you put it that way.  

edit:  got it to work perfectly with datatype=[string], wasn't much work to figure out how it would play out.  thanks again.