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

in

The in operator performs both word and substring searches on event properties, but functions differently based on the operations that the rule requires. The in operator provides the same functionality as the contains operator and the has operator except that the arguments are swapped.

The in operator computes the following types of object:

Item. An item is a property of an event, a text watchlist, or a single value returned from an operator function.

List. A list is a watchlist, an array returned from an operator function, or a temporary variable list.

Set. A set is an event set that is typically pooled from a WHEN n set rule.

Item

An item in an item returns true if the item on the left exists in the item on the right. When a rule includes two items, the in operator uses a substring match to check whether the item on the right contains the item on the left. For example, in the following rule, the operator checks whether the phrase, days is in the news tagline:

WHEN 1 news n WITH "days" in n.tagline then response

A list in an item returns true if any element in the list exists in the item on the right. When the rule includes a list and then an item, the operator uses a word boundary match to check whether the single item contains any of the items in the list. For example, in the following rule, the operator verifies whether any of the elements in the following watchlist is in the tagline:

WHEN 1 news n WITH watchlist:myList in n.tagline then response

A set in an item returns true if all elements in the set exist in the item on the right. When the rule includes a set and then an item, the operator uses a word boundary match to check whether all of the elements in the set are in the item. For example, in the following rule, the operator verifies whether all of the keywords of mySet is in the tagline:

WHEN 3 news n WITH mySet in n.tagline then response

List

An item in a list returns true if any element in the right list is an exact match to the item in the left list. When the rule includes and item and then a list, the operator checks whether any of the elements in the list is an exact match to the item on the left. For example, in the following rule, the operator verifies whether the watchlist, myList, is in the tagline:

WHEN 1 news n WITH n.tagline in watchlist:myList then response

A list in a list returns true if any element in the right list is an exact match for any item in the left list. When the rule includes a list and then a list, the operator checks whether any of the elements in the list on the right is an exact match to any item on the list on the left. For example, in the following rule, the operator verifies whether the tagline contains any of the elements in the myList watchlist:

WHEN 1 news n WITH n.tagline in watchlist:myList then response

A set in a list returns true if any element of the list is an exact match for all items in the set. The elements do not have to be the same element in the list. When the rule includes a set and then a list, the operator checks whether any of the elements in the list on the right is an exact match to all items in the set on the left. For example, in the following rule, the operator verifies whether the myList watchlist contains all of the elements in the tagline set:

WHEN 1 news n WITH n.tagline in watchlist:myKeywords then response

Set

An item in a set returns true if the item on the left exists in all elements in the set. When the rule includes an item and then a set, the operator uses a word boundary match to check whether the item on the left is an exact match to all items in the set. For example, in the following rule, the operator verifies whether the tagline set contains the keyword in the myItem watchlist:

WHEN 3 news n WITH myItem in n.tagline then response

A list in a set returns true if any element of the list exists in all elements in the set. The elements do not have to be the same element in the list. When the rule includes a set and then a list, the operator uses a word boundary match to check whether any element of the list exists in all items in the set. For example, in the following rule, the operator verifies whether the myList watchlist set contains all of the elements in the tagline:

WHEN 3 news n WITH n.tagline contains Watchlist:myList then response

When the set object contains a set, the contains operator returns true if all elements in the right set exist, using a word boundary match, in all elements in the left set . When the rule includes a set and then a set, the operator uses a word boundary match to check whether all elements in the right hand set exist in all elements of the left hand set. The elements do not have to be the same element in the left set. For example, in the following rule, the operator verifies whether the tagline set contains all of the elements in the mySet watchlist:

WHEN 3 news n, 3 Stock s WITH n.tagline contains s.symbol then response

Rename Saved Search

Table of Contents

User Guide

User Guide

in

in

Item

List

Set