Current Help System: PC-DMIS NC (View Core Help)

FILTER – This command defines a filter that will be used when data is loaded using the IMPORT command. Filters are used to define a trace field to limit imported data and to define start and end dates. By default there is no filter. The FILTER format is:

FILTER TraceName TraceValue StartDate EndDate;

- TraceName is the name of a trace field, for example MACHINE. Enter “” as a placeholder if trace field filtering is not being used.

- TraceValue is the value of a trace field, for example ROBODRILL. Enter “” as a placeholder if trace field filtering is not being used. If TraceName and TraceValue are defined, Only data that satisfies Tracename=TraceValue will be imported.

- StartDate defines the starting point of the data stream based on a date or count criteria. The options are:

LAST N – start at the N-th most recent measurement.

HOURS N – start at the beginning of N hours ago. If N is 0, start at the current hour. If n is 1, start at the beginning of the previous hour.

DAYS N – start at the beginning of N days ago. If N is 0, start at the current day (midnight). If N is 1, start at the beginning or yesterday.

The StartDate may be omitted, in which case no date filtering will be applied.

- EndDate defines the ending point of the data stream based on a date or count criteria. The options are:

LAST N – end at the N-th most recent measurement.

HOURS N – end at the beginning of N hours ago. If N is 0, start at the current hour. If n is 1, start at the beginning of the previous hour.

DAYS N – end at the beginning of N days ago. If N is 0, end at the current day (midnight). If N is 1, end at the beginning or yesterday.

The EndDate may be omitted, in which case all data after the start date will be used..

Some examples:

FILTER MACHINE ROBODRILL LAST 30 LAST 0; This is the last 30 measurements on the ROBODRILL machine

FILTER MACHINE ROBODRILL; This is all data made on the ROBODRILL

FILTER “” “” DAYS 0 LAST 0; This is all measured today

FILTER “” “”; This turns off all filtering