Load Samples

Topic Contents: Hide

The Samples dialog is used for loading samples into a query. The options for loading samples are very flexible and many methods of choosing samples are provided. The Samples dialog can also be used to edit or update the sample load options for a query. To open the samples dialog, expand a query in the Tree bar, right click on the Samples folder, and select Properties from the menu. After selecting the desired load options, click the View/Select Filters button in the Select Advanced Filtering region to filter you samples to get only the samples you desire to see.

Select how to order Samples from Database

When samples are loaded from the database, they can be ordered by:

·       Date - Sample Creation Date

·       Label

·       Description

·       Sequence - the order in which the samples entered the database

·       Serial # - Sample Serial Number

·       Filter - Select a filter from the Filter dropdown menu to the right

Select how to order Samples in Query

When Samples are loaded into the Query, they can be ordered by:

·       Date - Sample Creation Date

·       Label

·       Description

·       Sequence - the order in which the samples entered the database

·       Serial # - Sample Serial Number

·       Filter - Select a filter from the Filter dropdown menu to the right

·        No Sync - the Sample values will be loaded in the order they exist in the database, and will be synchronized by the last value for each sample, or the right-most cell in the dataset. This is useful when the Samples loaded are from different Routines and may not share Features (or other information) that is normally used to align them in the dataset. For example, say you loaded the following two Samples: Sample 1 (Feat3, Feat4, Feat5) and Sample 2 (Feat 21, Feat22).

§        If attempting to Synchronize, common information cannot be found and the data would be loaded as the following:

Sample 1 Feat3 Feat4 Feat5    
Sample 2       Feat21 Feat22

§        Using the No Sync Sample Load option, the data would be loaded as the following:

Sample 1 Feat3 Feat4 Feat5
Sample 2   Feat21 Feat22

Select the method for loading Samples

Do not load any Samples for this query

No samples will be loaded in the query.

Load all available Samples for this query

All existing samples in the query will be loaded.

Load the last __ Samples after skipping the last __ Samples

The set amount of samples will be loaded after skipping the last amount of samples selected. This is the only method of loading samples that enables the Use Cutoff Date option.

Example
If there are 20 samples, and Load the last 10 samples after skipping the first 10 samples is entered, samples 1-10 would be skipped and samples 11-20 would be loaded.

Load Samples with a creation date/time __ days __ hours __ minutes before today at ____

The samples for the designated time period will be loaded according to the date and time set the boxes. Entering a time in the "before today at" box will load all samples created prior to the current date and the time set in the box.

Load Samples with a creation date/time on or after ____ and on or before ____

The samples that were created between the selected dates will be loaded.

Load Samples with a creation date/time during a period of __ __ beginning __ minus __ __

All of the samples that were created during the designated period of time will be loaded. To set this up, first enter the number of days, weeks, months, or years you want to load. Next, enter your starting point, i.e. today, this week (counting from Sunday), this month (counting from the 1st of the month), or this year (counting from January 1st). Finally, enter the number of days, weeks, months, or years to where you would like to begin counting forward for the duration you selected in the "period of" field.

Load Samples Selected

The samples that are selected in the Select Samples dialog will be loaded. To open the Select Samples dialog, select the radio button next to Load Samples Selected, the click Select Samples.

To select samples from the list, click on them. To select multiple samples, hold down the Shift key and select a range of samples or hold down the Ctrl key and click on individual samples. Sample columns can be sorted (ascending or descending) by header labels by clicking on a header once, or twice to reverse the order.

·        Left Arrow - moves highlighted Selected Samples to the Available Samples list

·        Select All - moves all Available Samples over to the Selected Samples area

·        Right Arrow - moves the highlighted Available Samples to the Selected Samples list

·        Get Available - displays all of the samples that are available from the loaded routine in the Available Samples list

·        Clear Selected - removes any highlighting from the samples list

·        Clear Available - empties the Available Samples list

·        Set Options - opens a dialog similar to the Sample dialog which can be used to reduce the number of samples in the Available Samples list, in order to make it easier to find the exact samples you want

·        Set Filters - opens the Query Sample Filters dialog to apply a sample filter

·        Remove Columns with Same Values - when enabled, sample columns with identical values will not be displayed; to restore all sample columns, unselect the check box

Load Samples Like Query

Samples are loaded in the same manner as they were loaded in the selected query.

·       Query Select - Select the query that will be used as a model.

·       Sort Type - Select the type of sorting that you want to use.

Sample Cutoff Date

Samples with a creation date newer than (i.e. after) the Cutoff Date are available for loading. The samples that are available for loading are loaded using the Load the last __ samples method (the ONLY method of loading samples that relates to the Use Cutoff Date option).

·       Cutoff Type - All the samples are divided into categories based on the Cutoff Type

§        No Cutoff - No Cutoff date is used.

§        Absolute - uses a specific date entered in the field provided in the Sample Cutoff section of the Load Samples dialog; Samples with a creation date older than (i.e. before) the Cutoff Date are not loaded

§        Relative - uses a specific number of days in relation to the current date; Samples with a creation date older than (i.e. before) the Cutoff Date are not loaded

·        Cutoff Date - select the large down arrow to open a calendar; to set portions of the date or time, select the area within the field and either type in the desired information, or use the spin controls to set the values

Select Advanced Filtering

View/Select Filters

Samples can be filtered using pre-defined sample filters or user-defined values. The pre-defined sample filters are created in DB Utility or with the Query Sample Filters dialog in CM4D. Only filters with a defined type will be displayed in the Sample Filters dialog. Please refer to the Help Documentation for more information on creating sample filters in each respective application.

·       Label Filter - When entering a definition for a sample filter, wildcards such as the asterisk (*) can be used. For example, entering 5A* would return all samples starting with the characters '5A'. If wildcards are used to filter your samples, refer to your DBMS (Database Management System) Documentation for rules regarding wildcard usage in either Oracle or SQL Server.

·       Filters - The available sample filters will be listed in the Sample Filters dialog. To apply available filters, select the check box next to the filter name. Restricted filters will also have a menu next to the filter name containing further filter parameters. Filter types are indicated by the filter letter enclosed with braces {Restricted filter} or parenthesis (Unrestricted filter). After selecting the desired sample filters, you must also select how to apply the filters you have chosen. You can choose to include or exclude filters according to the following definitions:

§        Include - All samples with the selected filter assigned will be loaded.

§        Exclude - All samples with the selected filter assigned will not be loaded.

Skip Weekends

The skip weekends option is available for use in conjunction with the Load Samples Before Today or Load Samples During load methods.

·        Load Samples Before Today - skip weekends will ignore weekend days when counting and selecting the sample dates for the load

·        Load Samples During - skip weekends will ignore weekend days when counting and selecting the sample dates for both the minus days and period days; skip weekends is only available when the “days” option is selected for both the minus and period counts (period days are limited to 100 days or less)

Use Query Date

The Use Query Date option allows you to set a specific date to use as the Query date, rather than using the default current date when loading samples.

↑ Top