Print

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

[rbmjr]

I thought that I could use a global variable in the Add Rules section, however it seems that global variables only work in the Modify Results section (see attachment). Could you please add Global Variable usage in the Add Rules section?

[mark_h]

You need to use the Custom rule in the Add Rules section and build your own test that way.

Custom: [=compare([last played],>,load(gvRandom)]]=1

Or something like that.  It quite often helps to add an expression column to your view and work on this expression there until you have it right, and then move it into the smartlist rules, otherwise you spend a lot of time fiddling with that dialogue while you work through the code.

The stuff in the [] is your test - the =1 outside is the smartlist test for positivity, ie if your rule is true and the result should be included.

[rbmjr]

Thanks, I'll give that a try. I always wondered what the []=1 was for

[zybex]

The syntax for the left side is [=expression]; this expression can return any value which you then compare using the normal Smartlist operators. So for an expression that returns 0 or 1, you may do [=expression]=1, but for other cases you may want [=expression]="English","United States" or [=expression]=>3 for instance.

[mark_h]

Thanks, Zybex, I didn't know that!  That opens up some opportunities

[dtc]

Just to add - 0 and 1 are just computer values for FALSE and TRUE.  So, =1 just means that the previous expression is TRUE.

[rbmjr]

I finally figured it out.

[zybex]

The expression syntax is wrong, it should be:
[=compare([last played,0],<,math(now()-rand(60,90,1)))]=1

Your expression will always return 1 for any file due to how if() works with an invalid expression ("=<" is not valid in there)
(this applied to the expression on the previous screenshot, now replaced)

[rbmjr]

still have questions. So there is no need to preface [Last Played,0] with Math() in this compare statement:

[=Compare( Math( [Last Played, 0] ), < , Math( Now() - Load(GVRandom) ) )]=1

If I wanted to increase/decrease months or years when performing math on the value of Now() is there an easy way to do this as in:

Math( Now() + 1, y) or Math( Now() + 3, M)

[zybex]

Dates are measured in days, so you can do Math(Now()-31) or Math(Now()-365). If you need precise dates it gets a bit more complicated.

[marko]

If you need precise dates it gets a bit more complicated.

Don't they just. I still say a silent "thank you" to you (and Matt) for your help with leap years whenever I'm working in that area.

[rbmjr]

I learn so much through the Forum, thanks to everyone who helped.