Print

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

[Moe]

I'd like a way to return X number of items from a list type library field, call it something like ListLimit()

Description:	ListLimit(list, number to output) The ListLimit() function returns a defined number of items that exist in a list delimited by delimiter.
Example:	ListLimit([Actors], 4) Returns the first four values of the Actors field

   

Or something along those lines.

[Matt]

It's a good idea.  I'll add it to the next build.

[Moe]

Awesome, thanks Matt!

[Moe]

Matt, maybe this could be fleshed out a bit more?  Something along the lines of

ListLimit(list, offset, length, delimiter)

ListLimit([Actors], 0, 5)

Returns a list of 5 actors starting at index 0.

Additionally, use negative offsets to mean "from the end".

ListLimit([Actors], -4)

Returns the last 4 actors, or

   ListLimit([Actors], -5, -3)

Returns the first 3 actors of the last 5 actors in the list.

Just a thought, thanks again.

[Matt]

I'll integrate some of your idea in the next build:
Changed: Made the ListLimit MCWS function take an optional third parameter for the index to start at.

[Matt]

Doing another one now:
Changed: Made passing a negative number into ListLimit will grab that many from the end of the list.

Thanks for the ideas.

[Matt]

The changes are here:
https://yabb.jriver.com/interact/index.php/topic,121259.0.html

Thanks again.

[Moe]

Thank you!

[Moe]

Matt, this is working great but I have an issue.

Is there any way, when using ListLimit() in a custom library field to allow the field to be a list type field, right now it defaults to a string type. 

As an example, I have a field called [TMDB Actors] which is a list type field, it gets populated using MrC's MCUtils script which pulls 20 actors from TMDB.  I created a new expression field called [TMDB Actors Short] and I am using ListLimit([TMDB Actors], 5, 0) to cull that down to 5 actors.   

If I use [TMDB Actors] in Theater View it returns one actor per line which is how I want things to be handled.
If I use [TMDB Actors Short] it returns all 5 actors in one line (well, it wraps if it runs out of room, but still)

Hopefully that makes sense.

Thanks!

[Matt]

I can help with that!

Just add this to your expression for the field and it will become a list and after the formatting in Theater View should use newlines just like you were hoping:

Code: [Select]

&DataType=[list]

[Moe]

Ah, perfect.  Thank you!