3.3

Database Traits Console Command Summary
281
Sortfield
The format of the sortfield information is:
SRPlo-LIsUG-QSXWFiT sortfield
Q---------------- TITLE
This trait shows by which form field a sorted queue is sorted. A letter representing the form
field appears in this position in the trait listing. A hyphen (-) here means that no sort field has
been set. The system automatically uses the title field as the sort field.
This trait also determines which form field the computer searches during fast finds. In
addition, the cursor is placed on this form field when a user displays stories in a queue.
n
Do not confuse this trait with the sorted queue trait, which determines whether the queue is
sorted at all.
Changing a Queue’s Sort Field
Perform this procedure at a time of low system usage, because the dbsort command can
impair system performance while it is running.
To change a queue’s sort field from the console:
1. Esure no users are in the queue.
Changing a queue’s sort field does not affect what is seen by users already in the queue.
If they try to use a displayed out-of-date sort field, it could cause confusion.
FTS Index ftsindex # Assigns the index base used by the specified
directory. All directories default to zero (0).
Supported values are from 0 to 49.
Here are a few examples:
dbtraits wires ftsindex 1
dbtraits archive.2008 ftsindex 2
dbtraits archive.2009 ftsindex 3
Use the list d-i <directory> console
command to see which FTS index base is
associated with a specified directory.
Name
Location in Display
SRPlo-LIsUGQSXWFiT
Mode / Option
Keyword Definition / Example