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.2
- 6.1.2
- 6.1

Back Next

Equal and Not Equal Operators

You can use the equal and not equal operators to compare both text and numeric values.

You can use the equal and not equal operators for the following sets of conditions:

When the rule includes two items, the equal operator verifies that the left hand item is equal to the right hand item.

For example, the rule

WHEN 1 stock WITH price = 10

evaluates true after each of the following events arrives:


Topic: Stock
Event 1, Symbol ABCD, Price 10

Event 2, Symbol XYZ, Price 10

The rule,

WHEN 1 stock WITH symbol = "XYZ"

evaluates true after each of the following events arrives:

Topic: Stock
Event 1, Symbol XYZ, Price 9

Event 2, Symbol XYZ, Price 10

When the rule includes an item and a list, the equal operator verifies that the item must be equal to every item in the list. Consider an example of a set of three stock events. The equal operator verifies that all three stock event properties are equal to the item.

The rule

WHEN 3 stock WITH price = 10

evaluates true after each of the following events arrives:

Topic: Stock
Event 1, Symbol ABCD, Price 10

Event 2, Symbol XYZ, Price 10

Event 2, Symbol EFG, Price 10

The rule

WHEN 3 stock WITH symbol = "XYZ"

evaluates true after each of the following events arrives:

Topic: Stock
Event 1, Symbol ABCD, Price 11

Event 2, Symbol XYZ, Price 10

Event 2, Symbol EFG, Price 9

When the rule includes two lists, the equal operator verifies that both lists have the same items in the same order. If order of the items in the list is not relevant, use the contains analytic.

For example, consider two watchlists, MyPrices and MyStocks. The Watchlist type is list. Watchlist values for MyPrices are 10, 15, and 12. Watchlist values for MyStocks are XYZ, ABCD, and EFG. The rules in this example contains the equal operator that verifies that all three stock event properties are equal to the items in the specified watchlist.

The rule,

WHEN 3 stock s WITH s.price contains watchlist:MyPrices

evaluates true after the third of the following events arrives:

Topic: Stock
Event 1, Symbol EFG, Price 10

Event 2, Symbol XYZ, Price 15

Event 2, Symbol ABCD, Price 12

The rule,

WHEN 3 stock s WITH s.symbol contains watchlist:MyStocks

evaluates true after the third of the following events arrives:

Topic: Stock
Event 1, Symbol XYZ, Price 14

Event 2, Symbol ABCD, Price 11

Event 2, Symbol EFG, Price 13

Rename Saved Search

Table of Contents

User Guide

User Guide

Equal and Not Equal Operators

Equal and Not Equal Operators