NAPIS^® 'Step-by-Step' for Changing Query Preferences

Step 1. Open Table Interrogator:

In Windows Explorer navigate to 'c:\Program Files\Napis Lite\Utilities' and double-click the 'Table_Structure.exe' application. The program will open as shown.

To the top

Step 2. Set the 'Alias' name and the 'Table' name:

Click the down arrow to the right of the 'Aliases' field and select 'NAPIS_SYSTEM_LITE'. Use the pull-down list to the right of the 'Tables' field to select the 'QryPref.DB' table.

Note: If you are using a higher-level NAPIS product, select Alias = 'NAPIS_SYSTEM' instead. Edits made in 'NAPIS_SYSTEM_LITE' only affect NAPIS Lite, and edits made in 'NAPIS_SYSTEM' only affect NAPIS Enterprise or Laboratory.

To the top

Step 3. Click on the 'Data' tab and review the column headers:

The column headers and their descriptions are listed in the first table below. The second table defines the abbreviated LIMS functions that are represented by the * in the first table.

To the top

Column Header	Description
TableName	The name of the NAPIS table.
FieldName	The name of the field in the table.
DisplayName	The name that is displayed in the 'Query Fields Preferences' and 'Query Builder' dialogs.
*_Summary	These columns have an 'x' for a field that appears in the 'Query Fields Preferences' and 'Query Builder' dialogs for that specific LIMS function.
*_Default	These columns have an 'x' for a field that is always included for that specific LIMS function (it will appear in the gray box under 'Query Result Fields'), and an 'e' for a field that is always included in the Export file for a Submit.
*_Select	These columns have a value ≥ 0 for a field that is selected for that specific LIMS function. The fields appear in ascending order based on the value of this column (if the values in the column are equal, the fields will appear in alphabetical order).
*_ Export	These columns have a value ≥ 0 for a field that is selected for an Export file for that specific LIMS function. The fields appear in ascending order based on the value of this column (if the values in the column are equal, the fields will appear in alphabetical order).

Abbreviation	LIMS | function
TissueField	Inventory | Biomass Samples (Field)
TissueLab	Inventory | Biomass Samples (Lab Bank)
Collection	Inventory | Collection / Isolate
Voucher	Inventory | Voucher Specimens
MicroSource	Inventory | Microorganism Source Materials
MicroCryo	Inventory | Microorganism Cryo Preserves
Chemistry	Inventory | Chemistry Material Samples
MicroTiter	Inventory | Microtiter Plates
PlatePrep	Work Order | Microtiter Plate Preparation
Ferm	Inventory | Fermentation Samples (Fermentation Lab)
FermLab	Inventory | Fermentation Samples (Lab Bank)

Step 4. Edit fields as appropriate:

Double-click your mouse inside a box to edit that field. After entering a value click the 'checkmark' pictured below to post the edit. If there are no edits to post, the checkmark will not be highlighted (it will be a light gray instead of black).

To the top

We recommend that you do not edit the 'TableName' and 'FieldName' columns, as these are preset and accurate. However, if you find that the 'DisplayName' does not reflect what you use that field for, you may change it as you wish.

When you are editing the '*_Summary', '*_Default', '*_Select', and '*_Export' fields, make sure that you are working under the headings of the appropriate LIMS function.

Note that NAPIS is set up to smoothly transfer data from Inventory to Submit to Receive, so editing the '*_Default' column may lead to complications. If you have any questions, please contact White Point Systems.

Step 5. Close Table Interrogator:

Click the 'X' in the upper right hand corner to close Table Interrogator. Your posted edits will be automatically saved.