INTERACT FORUM

More => Old Versions => JRiver Media Center 26 for Windows => Topic started by: MusicBringer on February 21, 2020, 09:16:11 am

Title: Description field - a bit of help please
Post by: MusicBringer on February 21, 2020, 09:16:11 am

I am having a bit of trouble with the Description field.
Some records seem to have "pages" of text, whereas others have just a line or two, which I prefer.
How can I make a view to filter out and display the Description fields that contain more than say 100 characters of text.
thanks,
☺

Title: Re: Description field - a bit of help please
Post by: Moe on February 22, 2020, 02:05:55 pm

This should do it.  Put this in an expression column.  Any description longer then 100 will be marked "Over 100" any ones less than 100 will be marked as "Less Than 100".  You can go from there.

Code: [Select]

if(compare(length([Description]), >=, 100), Over 100, Less Than 100)

Title: Re: Description field - a bit of help please
Post by: MusicBringer on February 22, 2020, 06:51:14 pm

It works.

It works very well.
thanks,
 :)
What type of view would you think suits this.

Title: Re: Description field - a bit of help please
Post by: Moe on February 22, 2020, 07:30:30 pm

I would use a pane view, but I use pane views for pretty much everything.  But you could put that expression in one of your panes and with one click filter out all that are over 100.

Title: Re: Description field - a bit of help please
Post by: MusicBringer on February 23, 2020, 04:45:30 am

Yep, that's what I'm doing.
Thanks Moe 👍😊