SQLite Viewer - Edit column dialog



Type: The colum types below are available in this dialog. They are mapped to more detailed column types in the database.

Tag
Any tag, which is present in the foobar2000 media library or in the playlist can be used here.
TechInfo
Any technical info field, which is provided by foobar2000 can be used here.
Predefined
Several predefined fields are available
TFExpression
Any arbitraty title format expression can be defined here. The following predeifned values are available: %artist%, %album artist%, %title%, %track artist%.

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:

ARTIST
ARTIST_SORT
Motörhead
MOTORHEAD
Motörhead SPEARS, BRITNEY
Britney Spears
MOTORHEAD
Britney Spears SPEARS, BRITNEY

This result is probably not wanted. Defining ARTIST as associated column for ARTIST_SORT will lead to the desired result with only two rows:

ARTIST ARTIST_SORT
Motörhead MOTORHEAD
Britney Spears SPEARS, BRITNEY


Title format expression: Define the title format expression for columns with the type TFExpression.