Table 3-4: Filter Operands; Table 3-5: Wildcards - Siemens Sinumerik 840D sl Function Manual

DNC Plant/DNC Cell (FBDN1)
3 Operator interface
In Field Name, you can choose one of the items of administrative data of the
respective NC data.
In Operand, you can decide how you want to filter your NC data with the field
name you have chosen. The following options are available:

Table 3-4: Filter operands

Operand
=
<>
<
>
<=
>=
!
Caution
Before you change a filter, make sure that you have selected the correct filter in
the Select Filter dialog. You can check this in the title of the dialog for the filter
criteria (see above).
You can also use wildcards in the Value field. The following wildcards are
supported:

Table 3-5: Wildcards

DOS
wildcards
*
?
Note
The meaning of the DOS wildcards is the same as that of the SQL wildcards.
Wildcards are sent to the database as "like" queries. This means that the same
filter can have a different effect on different databases (MSDE, ORACLE, etc.)
depending on how these are configured. One example of this is the use of upper
and lower-case letters. The filter can also react differently depending on how the
wildcards or data fields are used.
FBDN1/3-40
Description
Equal
Not equal
Less
Greater
Less than or equal to
Greater than or equal to
SQL Description
wildcards
% Several
arbitrary
characters
One arbitrary
character
Motion Control Information System DNC (FBDN) - 04/10 Edition
to value
to value
than value
than value
value
value
Examples
c* cylinder_head, coil_plunger
%A TOA, ZOA, RPA
?PF MPF, SPF
_O_ TOA, ZOA, JOB
© Siemens AG 2010 All Rights Reserved
05.07