Skip to main content

V1 - Query - Field Starts-with Filter

sStartswith(field, value)​

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

sStartswith("@fields.isprime","y")

In the above example, the search matches all records where the value of the '@fields.isprime' field startswith the string 'ye'

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

sStartswith("@fields.isprime","Y")

Example​

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

search sStartswith("@fields.isprime","ye")
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