Print

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

[GreggP]

The latest MC11 build mentions:

"NEW: Added support for If(...), FixCase(...), and IsEqual(...) to expression evaluator."

Are there any examles showing how this is used?  Couldn't find it in the Help files.

Thanks

[EpF]

That help page doesn't explain the IF function... 

[EpF]

You're right! I got confused following posts!

I've got a question - should these functions work in the search bar?  In the help page I mistakenly mentioned, (http://www.jrmediacenter.com/DevZone/DBExpressions.htm), it says they do, but I don't think so...

Also, I'm not sure I understand Clean(...) and FixCase(...) - If you use them in a viewscheme, what happens; does it continually perform the Clean function, or only when you click on the viewscheme, or only when you click on the column in the viewscheme?

I realise that I could experiment, but I'd like to have some more info from JRiver as to the difference between functions which just return info, and functions which alter info.

Finally, if functions can both return and alter info, does this mean that the If(...) function enables automatic altering of info based on previous parameters.  For example, I have my own rating field called Artist Rating - can I now have a funtion which automatically fills in rating info for artists, like If(([artist]X), [artist rating]3)?  (or something like that - see; I need the If(...) function explained!!)