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

Query - Field Existance (Wildcard Value) Filter

  1. sWildcard(field)
  2. Example


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.


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