Skip to main content

V1 - Query - Field Existance (Wildcard Value) Filter

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