Query - Field Contains Filter

sContains(field, value)

The sContains filter is used to search the content of a field, for a string containing the value to be matched. This filter is case-insensitive.

search sContains("@tags","example")

In the above example, the search matches all records where the value of the ‘@tags’ field contains ‘example’ somewhere within.

Likewise, the following search will match the same data set:

search sContains("@tags","EXAMPLE")

Magic (regex) search over all fields

The field name can be left empty to perform a ‘magic search’ of a particular term in all fields. This action is equivalent to performing the regex search /example/ in the Event/Flow search pages.

search sContains("","example")

Example

The example below uses the demo-dataset from the introduction/tutorial page, dataset.

search sContains("@tags","Example")
let {id, isprime, odd, even} = f("@fields")

Note that the search filter does not return a presentable value. It is almost always following by the data extraction command ‘let’.

Page last updated: 2022 Oct 19