Preface
RulePoint
RulePoint Concepts
- RulePoint Concepts Overview
- Understanding RulePoint Entities
Using RulePoint
RulePoint Objects
- RulePoint Objects Overview
- State of RulePoint Objects
Working with Topics
Working with Connections
Working with Sources
Working with Responders
Working with Responses
Working with Watchlists
Working with Analytics
- Analytics Overview
- Analytic Types
- Creating an Analytic
- Copying an Analytic
- Editing an Analytic
- Deleting an Analytic
- Viewing Related Objects
- Predefined Analytics
  - abs
  - average
  - ceil
  - charat
  - clean
  - compareto
  - concat
  - confidence
  - correlation
  - count
  - current
  - date
  - datedifference
  - endswith
  - even
  - floor
  - getcurrentdate
  - getdatefrommillis
  - getdateinmillis
  - geodistance
  - geoinbound
  - geoinsidearea
  - geointersect
  - geooutbound
  - geooutsidearea
  - geopassthru
  - indexof
  - integer
  - isblank
  - isholiday
  - isnum
  - istext
  - isweekday
  - isweekend
  - large
  - list2vars
  - lower
  - max
  - min
  - mod
  - mode
  - mround
  - odd
  - parse
  - past
  - percentile
  - power
  - proper
  - range
  - regex
  - replace
  - round
  - rounddown
  - roundup
  - sign
  - small
  - startswith
  - stdev
  - stringequals
  - stringindexof
  - stringlastindexof
  - stringlength
  - substring
  - sum
  - trim
  - truncate
  - upper
  - xpath
- Predefined Operators
  - contains
  - equalsSet
  - has
  - in
  - match
  - notMatch
  - search
  - unique
  - group by
  - distinct
  - unmatched
- Using the distinct, group by, and ummatched Filters
DRQL
Working with Rules
Working with Alerts
Setting Access Controls
Troubleshooting RulePoint Issues
Connecting to an Ultra Messaging Application
Creating an Ultra Messaging JMS Source

User Guide

6.1.2
- 6.2
- 6.1

Back Next

AND and OR Operators

RulePoint evaluates AND and OR conditions from left to right.

The AND operator takes precedence over the OR operator. You should always use parentheses to group the conditions appropriately.

If the first part of an AND clause is false, RulePoint does not evaluate the remaining clause.

Consider the following rule:

WHEN 1 stock WITH s.price > 10 AND (symbol = "XYZ" OR symbol="ABCD")

To activate this rule, either both of the conditions around the AND operator (s.price > 10 and s.symbol = “XYZ”) must be met, or only the condition after the OR operator. The price of the stock topic event must be greater than 10 and its symbol must be XYZ, or the stock symbol of the stock topic event must be ABCD.

Use the OR operator ONLY between conditions for the same topic. For example, in the following rule, the OR operator applies only to the stock topic:

WHEN 1 stock s, 1 news n WITH s.symbol in n.title AND (s.symbol = "XYZ" OR s.symbol="ABCD")

When using the OR operator, all of the properties referenced in the conditions must exist in the events present in the system for RulePoint to evaluate a rule.

Rename Saved Search

Table of Contents

User Guide

User Guide

AND and OR Operators

AND and OR Operators