This function is used to produce a list of unique items from a column in an open query database. The list may consist of names or names and counts of occurrences.
Click here for information on identifying an open database.
If Use query results is not selected, the entire database is queried. When Use query results is selected, you must specify a named variable containing a list of keys suitable for querying the database. Typically this list will have been produced by an Issue Database Query statement. When specified, the new query is applied over the list as opposed to the entire database. With this mechanism you can limit the records used in the list production. Note that the list delimiter is always the \~ sequence.
The results are placed into the specified named variable. If Produce Counts is not specified, the list will consist of all unique values. The list items are separated by a \~ sequence. If Produce Counts is specified, a Yate key-value list will be produced. Keys will be separated from counts by a \k sequence, while the list items are separated by a \~ sequence.
You can specify that the unique test is Case Insensitive and/or Diacritic Insensitive. When either of these options are specified, the representation of the item returned on multiple matches is indeterminate.
You specify which column you want to access symbolically or numerically. A symbolic name must exactly match the name (case sensitive) of one of the database columns or all action processing will be terminated. When a query database is first opened the names of the columns are placed in a list in the Query Database-Names named variable. Numeric specifications are numbered left to right from zero.
When you select Ignore empty values, fields which are empty or consist only of spaces are ignored.
You can choose how you want the results list to be sorted, or not. If counts are not in the results, the Count sort types revert to the Alphabetic types.
All text fields may contain any of the escape sequences described in Escape Sequences.
The statement is only executed once for all execution modes.