INTERACT FORUM

More => Old Versions => JRiver Media Center 20 for Windows => Topic started by: Vincent Kars on January 15, 2015, 04:38:27 pm

Title: Groupcount syntax
Post by: Vincent Kars on January 15, 2015, 04:38:27 pm

Using an expression column I tried:
GroupCount([Bitrate]) - GroupSummary([Bitrate])

It doesn't work.
I inserted Bitrate using the Insert Field tool.

GroupCount(Bitrate) - GroupSummary(Bitrate)

It works as soon as one removes the [ and ]

Is this done on purpose?
I do think it a bit confusing if there are functions requiring [] and some that don't.

Title: Re: Groupcount syntax
Post by: 6233638 on March 14, 2015, 03:27:43 am

I agree, this is confusing. I thought fields were always supposed to be enclosed in square brackets?
 
I'm also seeing a huge reduction in performance when using GroupCount(Album) in a view with about 500 albums for example. Scrolling becomes very slow/unresponsive.

Title: Re: Groupcount syntax
Post by: Matt on March 14, 2015, 07:51:50 am

Quote from: Vincent Kars on January 15, 2015, 04:38:27 pm

Is this done on purpose?

Yes.

That's how it works.

You want to put the field name and not the field value into the GroupCount(...) / GroupSummary(...) functions.