where operator filters rows, returning only rows that satisfy the the provided boolean expression.
To find the events containing an email address that ends with
.gov, use the query below:
Loading APL Editor...
Here are a few other boolean expressions to try:
first_name == "Willard"
gender != "Male"
id < 3
ip_address matches regex "67.*"
Boolean expression can also be combined using
ip_address matches regex "67.*" or gender != "Male"
Try updating the query to find records last name
Frediani or an ip address containing
To learn more, see the where docs.