Skip to main content

V1 - Query - Field Ends-with Filter

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