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. |