INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: EpF on August 13, 2005, 10:04:32 am

Title: Broken Expression Evaluator?
Post by: EpF on August 13, 2005, 10:04:32 am

Is the Expression Evaluator working in MC 11.0.311?  My 'File Exists?' expression isn't working anyway;

(http://www.alluvialplains.com/Images/MC/expression.jpg)

As you can see from the status bar, MC can find the file..  The expression I'm using is:  if(IsMissing(), No, Yes).

Title: Re: Broken Expression Evaluator?
Post by: marko on August 13, 2005, 01:32:11 pm

try if(ismissing([filename]),yes,no)

myself, I figured that if I was checking for missing files, the "no" results are redundant and wouldn't ever be clicked on. to that end, I set mine up like so....

(http://www.theganghut.co.uk/pics/ia/missing.jpg)

which returns a list of nothing but missing library entries.

-marko.

Title: Re: Broken Expression Evaluator?
Post by: hit_ny on August 13, 2005, 02:54:58 pm

That got me for a bit as well ?

They deprecated FileExists some time back.

Title: Re: Broken Expression Evaluator?
Post by: EpF on August 13, 2005, 04:17:05 pm

Quote

try if(ismissing([filename]),yes,no)

That got 'er!  Thanks Marko.  By the way, what is that usage of square brackets and '=' sign?  It's not from the DB Expressions help page I'm sure..  Is it a special format for MC Search fields, like in smartlists?

Title: Re: Broken Expression Evaluator?
Post by: marko on August 13, 2005, 09:02:37 pm

Quote from: EpF on August 13, 2005, 04:17:05 pm

Is it a special format for MC Search fields, like in smartlists?

Got it in one :)

Quote from: Matt on December 09, 2004, 05:31:54 pm

To use an expression in a search, do this: [=EXPRESSION]=
Example to find missing files: [=FileExists([Filename])]=0