Project Definitions Database
Database
Microsoft Access
The project definitions database is named <project>02.def, where <project> is the name of the Vector HelpDesk project.
SQL Server
The project definitions database is named <project>02_DEF, and consists of these files:
<project>02_DEF.mdf
<project>02_DEF_log.LDF
Tables
tblDtsFields
Defines the fields available in a Vector HelpDesk project. The Field Editor in HelpDesk Admin provides a user interface for editing most of the columns in this table.
In tblDtsFields, the tWhere column specifies a Where clause that controls the contents of a choice list. The HelpDesk project uses the Where clause to build the Contact, Owner, and Submitter choice lists.
For example, this Where clause removes macros (such as <User>) and contacts from the Owner list:
Where (([nID] >= 0 And [tName] <> '')Or
[tName] = '<User>') And fOriginator = 0
The
[nID] >= 0 condition removes the macros defined in tblUser:
User ID |
User Name |
-4 |
<Contact> |
-3 |
<User> |
-2 |
<Previous Owner> |
-1 |
<Owner> |
The user with nID = 0 is the <None> macro.
The
fOriginator = 0 condition removes contacts, so that the list contains users
only.
tName
is the name of the user.
tblState
Specifies the list of choices for the State field. The State field is a read-only field that is set based on the Progress field.
tblSubState
Specifies the list of choices for the Progress field. Each possible substate corresponds to a possible State value (Open or Closed).
Choice List Tables
A choice table specifies the possible values for a choice list field. Each row in a choice table includes an nID, a tName (the choice text), and optionally, an nChoiceID (for non-alphabetical choice lists).
In the issue database, multi-choice fields store a semi-colon separated list of the tName values (the choice text strings), not the nID values.
Related Topics
Relocating Databases to SQL Server