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

No query result to show, please click the 'run query' button above!

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 and and or:

  • ip_address matches regex "67.*" or gender != "Male"

Try updating the query to find records last name Frediani or an ip address containing 255.

To learn more, see the where docs.

Was this page helpful?