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

Referencing Temporary Variables in Responses

You can specify temporary variables previously defined by the AS clause in responses.

To specify the temporary variables, you can set the analytic result as a variable, and then define a condition for the result as shown in the following response:

WHEN 3 stock s, dailystockinfo d group by s.symbol with average(s.price) AS AvgPrice > 0 AND AvgPrice > d.threedayaverage THEN EmailBrokerResponse WITH to="broker@company.com", body="XYZ is trading at the average price of ${AvgPrice}."

The group by analytic forces the response to evaluate matching symbols.

Setting the analytic result as a temporary variable enables you to reference the result in the responses. Using the previous example, you can include the AvgPrice temporary variable in the response DRQL to display its value in the response.

The assignment of a particular result to a temporary variable is valid only during the evaluation of that rule. After the evaluation, the value of that temporary variable is removed.

Rename Saved Search

Table of Contents

User Guide

User Guide

Referencing Temporary Variables in Responses

Referencing Temporary Variables in Responses