Operator | Usage scenario | Example |
---|
AND | A AND B | Type = Image AND Domain = Root |
OR | A OR B | Type = Text OR Type = Image |
NOT (1) | A AND NOT(B) | Type = Image AND NOT(Topic = Mountains) |
NOT (2) | A AND NOT( B OR C) | Type = Image AND NOT((Topic = Mountains) OR (Topic = People)) |
NOT (3) | (A OR B) AND NOT(C) | ((Workflow target = Person 1) OR(Workflow target = Person 2)) AND NOT(Created by = Person 3) |
RELATION (1) | RELATION(Direction, Type) | RELATION(Direction = Parent relation, Type = Placement) |
RELATION (2) | RELATION (A) AND RELATION (B) | RELATION(Direction = Parent relation, Type = Planning) AND RELATION (Direction = Child relation, Type = Placement) |
RELATION (3) | RELATION (A AND RELATION(B)) | RELATION((Direction = Parent relation, Type = Planning) AND RELATION(Direction = Child relation, Type = Placement)) |
AND, NOT, RELATION | A AND NOT(B) AND RELATION(C) | Type = Image AND NOT(Topic = Mountains) AND RELATION(Direction = Parent relation, Type = Placement) |
AND, OR (1) | A AND (B OR C) | (Type = layout) AND ((Workflow target = person 1) OR (Workflow target = person 2)) |
AND, OR (2) | A AND B AND (B OR C) | (Type = Image) AND (Domain = Magazine 1) AND ((License = Free) OR (License = fees apply)) |
AND, OR (3) | (A AND B) OR (C AND D) | ((Type = Event) AND (Domain = Magazine 1)) OR ((Type = Ad) AND (Domain = Magazine 2)) |
AND, OR (4) | (A OR B) AND (C OR D) | ((Workflow target = Person 1) OR (Workflow target = Person 2)) AND ((MIME type = JPEG image) OR (MIME type = PNG image)) |
<, <=, =, >, >=, !=, in, like | all relational operators | MIME type != JPEGimage, width > 40 |