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
- 6.2
- 6.1.2

Back Next

Watchlist Response Example

You can run the response with its default values using the following syntax:

WHEN 1 stock with symbol="XYZ" THEN WatchlistStockResponse

In this SQL query, WatchlistStockResponse is the name of the response.

The following rule provides the syntax for adding a value to the watchlist:

WHEN 1 stock s WITH s.symbol="XYZ" THEN WatchlistStockResponse WITH objectName="Stock", action="add", newValue="${symbol}"

The following rule provides the syntax for deleting a value from the watchlist:

WHEN 1 stock s WITH s.symbol="XYZ" THEN WatchlistStockResponse WITH objectName="Stock", action="remove", oldValue="${symbol}"

The following rule provides the syntax for changing an existing value in the watchlist:

WHEN 1 stock s WITH s.symbol="XYZ" THEN WatchlistStockResponse WITH objectName="Stock", action="change", oldValue="ABCD", newValue="${symbol}"

The following rule provides the syntax for replacing all of the values in the watchlist:

WHEN 1 stock s WITH s.symbol="XYZ" THEN WatchlistStockResponse WITH objectName="Stock", action="replace", newValue="${symbol}"

Rename Saved Search

Table of Contents

User Guide

User Guide

Watchlist Response Example

Watchlist Response Example