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

Query - Field Ends-with Filter

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

sEndswith(field, value)

The sEndswith 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.

sEndswith("@fields.isprime","o")

In the above example, the search matches all records where the value of the ‘@fields.isprime’ field ends with the string ‘o’

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

sEndswith("@fields.isprime","NO")

Example

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

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