Print

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

[rossp]

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

[MusicHawk]

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.

[rossp]

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