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

Query - Field Starts-with Filter

Sections
  1. sStartswith(field, value)
  2. Example

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