Siemens Sinumerik 840D sl Function Manual page 110

DNC Plant/DNC Cell (FBDN1)
4 NC data management
Managing the filter criteria
The DNCFILTERCOLUMN database table is used to manage the individual filter
criteria. In this table, each criterion of a filter is represented as a data record. As a
result, DNCFILTERCOLUMN contains x data records for one data record in the
DNCFILTERHEADER table.
It is structured as follows:

FILTERHEADER_ID is the assignment of a criterion to a filter in the
DNCFILTERHEADER table.

ROWNUMBER defines the order in which the criteria appear in the filter criteria
dialog.

COLUMNNAME defines the column name that is filtered.

TYPE defines the data type of the column name (a distinction is made, for
example, according to date, integer, flag, character, etc.).

OPERATOR defines the operator (equal to, not equal to, greater than or equal
to, etc.).

CONDITIONVALUE defines the value that is filtered.

FLAGS indicates whether this criterion is active or inactive (checkmark in the
filter criteria dialog).
Managing the filter assignments
The DNCFILTERASSIGN database table is used to manage the filter assignments.
It is structured as follows:

FILTERASSIGN_ID is a system-internal variable that is assigned
automatically.

FILTERHEADER_ID is the assignment of a criterion to a filter in the
DNCFILTERHEADER table.

NODEID is used to assign a filter to a machine for DNC IFC SINUMERIK.

STATION defines the station for which the filter was configured.

TABLENAME defines the table to which the filter belongs (DNCDATA or
DNCLOG).

USERNAME defines the user for which this filter was configured.

APPLICATION defines the application for which this filter was configured.

SUPPLEMENT1

SUPPLEMENT2
FBDN1/4-102
© Siemens AG 2010 All Rights Reserved
Motion Control Information System DNC (FBDN) - 04/10 Edition
05.07