The expression language is largely used to evaluate one file at a time. The grammar implies that something like Field(Artist) should get the Artist value for the current file being evaluated. Grouping Functions are a special class of functions that operate on a group of files, instead of on individual files. A simple example would be a function to count the number of artists in the current group.
Grouping Functions may only be useful in relevant areas where Media Center displays groups of files (most notably in Categories and the Tag Action Window), and not to individual file listings, such as an expression column in a File Details View, where they can be used, but will not be all that useful.
The GroupCountQuery() and GroupSummaryQuery() functions detailed below are special functions that work globally, returning results from the entire library, regardless of Media Type, or any other filters currently in action. This makes them especially useful for presenting information in Theater View, where typically, 1 file is represented, pertaining to given fields shared with this single file, such as number of tracks in an album, or total duration of the album this track is a part of. For use in Theater View, these would be entered by editing the Theater View File Info Panel
- Counts the members of a specified group (in a category or field).
GroupCount() can be used to count the members of a group of files.
- Globally counts the number of different Field 2 entries for files that share Field 1 with the current file.
|Description|| GroupCountQuery(field 1, Field 2)
|Examples|| [album artist (auto), 1] (GroupCountQuery(album artist /(auto/), album) albums)
GroupCountQuery(album artist /(auto/);Camera, album)
- Summarises the members of a specified group (in a category or field).
Smartly summarizes the members of a specified group (mode, mean, min, max, etc as is most logical for that grouping).
- Globally summarises the Field entries for files that share a Match with the current file.
|Description|| GroupSummaryQuery(Match, Field, Mode)
Available mode values:
|Examples|| GroupSummaryQuery(Album, Duration)
Album Rating: GroupSummaryQuery(Album,Rating,1) out of 5