INTERACT FORUM
More => Old Versions => Media Center 15 (Development Ended) => Topic started by: rossp on June 12, 2010, 04:29:49 am
-
Hi all, I need some help with an expression I am trying to use that will sort video's by Year and if that is empty by ProductionYear.
I have tried
if(isEmpty([Year],1),[ProductionYear],[Year])
But this has no real effect. I am using a copy of the video/Dates view with Month removed and Year modified with this expression.
Ross
-
Using MC 15.0.57 I tried a quick experiment, simplifying the expression to see if the conditions do what is expected.
This works:
If( IsEmpty([Year],1), EMPTY, not empty )
In my database, which has a mix of records with/without a Year field value, this expression in a column displays the appropriate text for each row, either "EMPTY" or "not empty". (I don't find any difference with/without the optional IsEmpty argument 1.)
So maybe the problem is with the two fields you are trying to display: ProductionYear and Year? I didn't try that because I don't have any records with a ProductionYear value.
-
OK I think I have it.
Step 1) Create a new library field called TmpYear and fill it with an expression 'ListCombine([ProductionYear],[Year])'
Step 2) Create a new view to use TmpYear and group by TmpYear.
Thats it... Ross