Skip to main content Link Search Menu Expand Document (external link)

Query - Field Existance (Wildcard Value) Filter

Sections
  1. sWildcard(field)
  2. Example

sWildcard(field)

The sWildcard filter is used to match any value (a wildcard) in a field. In other words the sWildcard(<col>) query matches when the value of the column <col> exists.

search sWildcard("@fields.odd")

In the above example, the search matches all records where the field ‘@fields.odd’ exists.

Example

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

search sWildcard("@fields.odd")
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 02