NAPIS® 'Step-by-Step' for Work Orders (Microtiter Plate Preparation)

YOU ARE MAKING A TRANSACTION WITH THE DATABASE when working in Microtiter Plate Preparation.

Step 1. Open the Microtiter Plate Preparation Work Order Form:

From the NAPIS main menu select LIMS | Work Order | Microtiter Plate Preparation to open the Microtiter Plate Samples Inventory form shown below

This Work Order form differs from other Work Orders because you can set the Query Preferences to control the output file, and there is a 'To Create' button on the form. In this work-flow you are querying inventory to group samples for plating

Microtiter Plate Samples Inventory To the top

Step 2. Set the Query Preferences:

From the menu-bar select Query | Preferences to open the Query Fields Preferences dialog. In this Step you are controlling the number of columns in your query results set

Query Builder To the top

Individually highlight each field in the left-hand 'Available Fields' list and use the arrow buttons in the center to move them to the right-hand side 'Query Result Fields'. This will select the fields you want to appear in your query result, in the order you want them to appear

Note: Use discretion in selecting those fields that are important for your result. The query is dynamically created in SQL using a 'SELECT DISTINCT' statement based on the query preferences. You may get a different number of rows returned by your query because of your selected fields

The 'Available Fields' choices that appear are specific for the Biomass Sample Inventory, and are easily customizable

Step 3. Define and Run the Query:

From the menu-bar select Query | Define and Run Query to open the Query Builder dialog. In this Step you are controlling the number of rows in your query results set

Query Builder To the top

Build the query by highlighting a value in the left-hand 'Fields' list, which is filtered to show only those fields related to the selected Inventory function. 'Values' for the highlighted field should appear on the right-hand list; if they do not, uncheck the 'Do not show distinct values' box in the top right and begin again

Double-click the highlighted field in the left-hand list (confirm that text appears in the data window at the bottom of the form) then single-click a Boolean operator button like '=' in the center (confirm that text appears in the data window), and then double-click a highlighted value from the right-hand 'Values' list (again, confirm that text appears in the data window)

Click the 'Run Query' button to execute

Step 4. View the Query Result:

Your query will dynamically display on the Inventory form with the column-header preferences you set. You can drag these column-headers along the top of the grid to change their order. You may edit the number of rows included in the result by selecting a row and holding 'Ctrl' and 'Del' on the keyboard. You are not making a transaction with the database on this form, only working with a temporary view of data

Microtiter Plate Samples Inventory To the top

Step 5. Migrate the Data to the Microtiter Plate Preparation form and Set the Plate Template:

Click the 'To Create' button on the body of the Inventory form to migrate the data to the Microtiter Plate Preparation form as shown below

Select a value from the 'Plate Layout' pull-down menu on the upper right-hand side of the form to set the Plate Template. More information about how to create a plate template can be found in the Plate Template description

Microtiter Plate Preparation To the top

Step 6. Assign Wells:

Click the 'Auto Assign' button on the body of the Microtiter Plate Preparation form to set the well assignments, or manually enter them into the grid. It is possible to drag-and-drop the wells on the template in the lower right of the form

Microtiter Plate Preparation To the top

Step 7. Set Values for the Microtiter Plate:

Click the 'Set Values' button on the body of the Microtiter Plate Preparation form to open the Set Microtiter Plate Values dialog. Enter values as prompted. The available values for the 'Solution Code' field are customizable through the Utilities Lookup editor (select the PL_SOLUTION table)

Set Microtiter Plate Sample Values To the top

Step 8. Make the Work Order transaction with the database:

Click the 'Create' button on the body of the Microtiter Plate Preparation form to open the Create Microtiter Plate dialog. Enter values as prompted

Create Microtiter Plate To the top

The Transmittal No. and Plate ID must be unique values

The Plate Code field is for the design and construction of the plate. The available values for this list are customizable through the Utilities Lookup editor (select the PL_TYPE table)

The Plate Category field is for the type of samples the plate contains, e.g. plant. The available values for this list are customizable through the Utilities Lookup editor (select the PL_CAT table)

The Plate Format field is for the plate template layout. The available values for this list are customizable through the Utilities Lookup editor (select the PL_FORMAT table)

The Preparation Date and Expiration Date 'Set' buttons open a calendar, where a date is selected using mouse clicks, not entered at the keyboard

Enter a value for the number of replicate plates created

The Investigator pull-down list can be managed through Utilities Personnel

The Status pull-down list is customizable through the Utilities Lookup editor (select the N_STATUS table)

Enter an address for the Storage of the microtiter plate

The Note field is for recording a description of the plate. It is not searchable in the database, but may be used in reporting

Select the checkbox to Generate a Plate Detail File in the 'c:\...\Napis ...\Submit directory

Click 'OK' to proceed

An information dialog will appear and prompt you to COMMIT to making a transaction. You cannot undo the Work Order after clicking 'Yes' on this dialog. A Text file will be saved to the 'c:\Napis Enterprise\WorkOrder' directory