Print

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

[StiX]

It would be very useful to have a Function, which could gather Quantity of Database Entries with Same Value of Specified Field.
I think it should not be a problem to add such a function, as MC already can show Statistical information in Action Window > File Properties > Statistics > Artist / Album. While it's a little bit useless there, such a functionality will be useful as a function.

Now, how it should work and what parameters it should have? My proposals about naming the function: DataEntries(), FieldInstances(), TotalFieldEntries(). Something like that.

There should be only one parameter: a [Field] or some Keyword.

Example of resulting functionality.
Let's say we want to see a View with following information
      [Album] : TOTAL_TRACKS_OF_CURRENT_TRACK_ALBUM
We would create an expression
      [Album] : DataEntries([Album])

Another example:
      [Genre] : DataEntries([Genre])

[hit_ny]

OK, how would you make a data expression that displays totals by field (in this example genre)  in a column of a viewscheme, using the above.

The result should show

Genre 1 (total albums)
Genre 2 (      "            )
.
.
Genre n (    "              )

Note we are in effect programming the output of one column of a viewscheme here.

[StiX]

Not really understand what are you complicating on this.

The result should show:

Code: [Select]

Genre 1 (total_files_of_this_genre)
Genre 2 (total_files_of_this_genre)
.
.
Genre n (total_files_of_this_genre)
The output of this would be useful not in Table Columns, but in "Top View Columns".

[hit_ny]

Not really understand what are you complicating on this.

The result should show:

Code: [Select]

Genre 1 (total_files_of_this_genre)
Genre 2 (total_files_of_this_genre)
.
.
Genre n (total_files_of_this_genre)
The output of this would be useful not in Table Columns, but in "Top View Columns".

I am referring to the panes columns, is this the same what you mean by "Top View Columns" ?

If so...yes that is what i was looking for.

[Matt]

These functions would be nice, but there are some performance implications.

When one function accesses every entry in the database instead of just the one it's working with it exponentially adds to the overhead.

[hit_ny]

Ahh...was afraid you would say that.  Was trying to get away from excel for this sort of thing.

The only way i can see around this is to pre-calcualte them somehow..but it becomes messy.

[StiX]

I wouldn't say that there are any performance implications in the Action Window > Statistics

By selecting all files in the Library, the table in Statistics > Albums updates almost instantly...