Type: | The colum types below are available in this dialog. They
are mapped to more detailed column types in the database.
|
||||||||||||||||
Name: | Define the Name of the column. Dependent on the column type either a predefined value needs to be selected or an arbitrary name can be entered. | ||||||||||||||||
Collation: | Define the default collation of the column. Besides the custom collation NaturalNoCase also the standard SQLite collations Binary, NoCase and RTrim are available. | ||||||||||||||||
Name
(Tag): |
Define the name of the tag, which is assigned to the column. If it is empty, the column name will be used.Only available vor columns with the type tag. | ||||||||||||||||
Multivalue separator (Tag): | Define the separator, which is used for concantenating multiple values in columns with the type Tag. | ||||||||||||||||
Split multivalue tag
(Tag): |
If checked, multivalue tags
will be splitted and for each value a separate row will be
added to a query of the MediaLibrary or Playlist table. Only
available for columns with the type tag. |
||||||||||||||||
Associated
column (Tag): |
Define an associated column
for the current column. This attribute is only available, if
"split multivalue tag" is selected and the associated column
should also have this attributes selected to get meaningful
results. Each value of the current column is the value of
the associated column at the same position assigned. To get
not only <null> values for the current column the
associated column needs to appear either in the select list
or in the where clause. For example a track has two multivalue tags, each with two values in: ARTIST=Motörhead; Britney Spears ARTIST_SORT=MOTORHEAD; SPEARS, BRITNEY Without defining an associated column a query, which contains this track will have four rows in its result:
This result is probably not wanted. Defining ARTIST as associated column for ARTIST_SORT will lead to the desired result with only two rows:
|
||||||||||||||||
Title format expression: | Define the title format expression for columns with the type TFExpression. |