INTERACT FORUM

More => Old Versions => Media Center 17 => Topic started by: locust on November 14, 2011, 09:58:18 pm

Title: Nesting Decades in panes?
Post by: locust on November 14, 2011, 09:58:18 pm

Is there a more elegant way to nest decades than this? Maybe one that isn't so expression intensive.. I'm trying to optimise my views and don't want to over burden my view schemes with any unessential labour intensive expressions..

listbuild(1,\,removeright(formatrange([Year],10,2),5)'s,removeleft([Year],3))&datatype=[list]

Thanks

Title: Re: Nesting Decades in panes?
Post by: rick.ca on November 14, 2011, 10:47:21 pm

FormatDate([Date, 0], Decade)\[Year]&DataType=[List]

Title: Re: Nesting Decades in panes?
Post by: locust on November 14, 2011, 10:49:48 pm

Cheers, mate  :)

One step closer to a perfect setup  ;D

Title: Re: Nesting Decades in panes?
Post by: MrC on November 14, 2011, 11:17:43 pm

Rick's expression is nicer, but here's one using the basic format you used, and deals with Unassigned Years:

Code: [Select]

if(isempty([Year]), Unassigned,
                   listbuild(1, \, removeright([Year], 1)0's, 'removeleft([Year], 2)&datatype=[list])</nobbc>

Title: Re: Nesting Decades in panes?
Post by: locust on November 14, 2011, 11:41:10 pm

That was along the lines I was going for, I think Rick expression will be less intensive on the cpu though.

I'm not really bothered about my expressions checking if there is a value.. I've got a custom scheme that is setup specifically for tag maintenance. I like to keep that stuff separate from my main view schemes.

Thanks anyway, it's cool so see multiple ways of doing the same thing   :)

Title: Re: Nesting Decades in panes?
Post by: MarkCoutinho on November 15, 2011, 04:00:04 am

Forgive me, but as I'm Dutch I don't understand the meaning of 'to nest decades'. I think it might be of interest to me too, so can someone describe or 'translate' the meaning of this?

Thanks!

Title: Re: Nesting Decades in panes?
Post by: rick.ca on November 15, 2011, 04:36:12 am

I'd be lost without them...

Title: Re: Nesting Decades in panes?
Post by: JimH on November 15, 2011, 07:33:22 am

Quote from: MarkCoutinho on November 15, 2011, 04:00:04 am

Forgive me, but as I'm Dutch I don't understand the meaning of 'to nest decades'. I think it might be of interest to me too, so can someone describe or 'translate' the meaning of this?

Nested means something like "contained within".  Explorer has folders nested within folders, for example.

Decades are the 1960's, 1970's, etc.