How to filter your row data

This document briefly explains how to use the data filter syntax.

If a column name contains any of these special characters ~ ( ) # \ / = > < + - * % & | ^ ' „ [ ], you must enclose the column name within square brackets [ ]. If a column name contains right bracket ] or backslash \, escape it with backslash (\] or \\).

"id = 10";      // no special character in column name "id"
"$id = 10";     // no special character in column name "$id"
"[#id] = 10";   // special character "#" in column name "#id"
"[[id\]] = 10"; // special characters in column name "[id]"

String values are enclosed within single quotes ' '. If the string contains single quote ', the quote must be doubled.