Manuals - PARTsolutions Admin

6.1. Constants, Functions, Operators, mathematical expressions

6.1.2. SQL Syntax

	Note
In the context of PARTdesigner/PARTproject, no SQL-Syntax may be used. This is especially used in the context of Strategic Parts Management. Example: Roles -> Filter condition for datasets

Note

In the context of PARTdesigner/PARTproject, no SQL-Syntax may be used. This is especially used in the context of Strategic Parts Management.

Example: Roles -> Filter condition for datasets

=     gleich
<>    ungleich
>     größer
<     kleiner
>=    größer gleich
<=    kleiner gleich
AND
OR

The following examples show key values:

```
1
```
The expression is always true.
```
ERPTABLE.PREIS<=0.8
```
The expression is true if the relevant field in the PRICE column has a value less than or equal to 0.8.
```
LINKTABLE.ERP_PDM_NUMBER<>''
```
The expression is true if the relevant field in the ERP_PDM_NUMBER column is not empty.
```
(LINKTABLE.ERP_PDM_NUMBER<>'') AND (ERPTABLE.PRICE3>0.0)
```
The expression is true if the relevant field in the ERP_PDM_NUMBER column is not empty AND the relevant field in the PRICE column has a value greater than 0, i.e. a price specification exists.
```
((LINKTABLE.ACTIVE_STATE=1) AND (ERPTABLE.STANDORT1<>''))
```
The expression is true if the field in the ACTIVE_STATE column has the value 1 (=released) AND the field in the STANDORT1 column is not empty, i.e. it has an entry.

Prev	Up	Next
6.1.1. Fortran Syntax	Home	6.1.3. Constants