Table filter guide

Complete reference for simple filters, wildcards, RegEx, safe SQL, natural language and the visual query builder.

All filtering runs locally in your browser over the rows already displayed. SQL mode never executes database commands and natural-language filters are not sent to an external AI service.

1. Simple filtering

Type in any column filter. The row remains visible when the cell contains that text. Searches ignore upper/lower case and accents.

ESP · Alvaro · 100

2. Wildcards (Dynamics-style)

Command	Meaning	Example
*	Any number of characters	`Al*`
?	Exactly one character	`Jo?n`
!	Exclude a pattern when placed first	`!ESP`
, or \|	Match any listed pattern	`ESP\|AUT`
..	Inclusive numeric or text range	`50..100`

3. RegEx (ECMAScript)

Use JavaScript regular-expression syntax. Patterns are case-insensitive by default; /pattern/flags syntax is also accepted.

Command	Meaning	Example
.	Any single character	`a.c`
^ $	Start and end of the value	`^ESP$`
* + ?	Zero or more, one or more, optional	`ab+c?`
*? +? ?? {n,m}?	Lazy quantifiers return the shortest possible match	`.*?`
{n} {n,} {n,m}	Exact, minimum or bounded repetitions	`\d{2,4}`
[abc] [a-z] [^x]	Character sets, ranges and negation	`^[A-Z]`
\d \D \w \W \s \S	Digit, word and whitespace classes and their negations	`^\d+$`
\b	Word boundary	`\bESP\b`
\| ( ) (?: )	Alternatives, capturing and non-capturing groups	`ESP\|AUT`
(?<name> ) \1 \k<name>	Named groups and numeric/named backreferences	`(\w+)\s+\1`
(?= ) (?! ) (?<= ) (?<! )	Positive/negative lookahead and lookbehind	`\d+(?= pts)`
\p{...} \P{...}	Unicode property classes when using the u or v flag	`\p{L}+`
/pattern/dgimsuvy	Optional JavaScript RegEx flags	`/esp\|aut/iu`
\	Escape a special character	`\.`

4. Safe SQL query

Write a WHERE-style expression using column headers. Put headers containing spaces inside [square brackets]. Only row-filter operators are accepted.

WHERE Puntos >= 100 AND Subsidiary IN ('ESP','AUT')

[Jugador] LIKE 'Al%' OR [Puesto] BETWEEN 1 AND 10

Command	Meaning
= != <> > >= < <=	Comparison operators
LIKE / NOT LIKE	SQL wildcards: % for any text and _ for one character
IN / NOT IN	Match or exclude a value list
BETWEEN / NOT BETWEEN	Inclusive range
IS NULL / IS NOT NULL	Empty or non-empty cell
CONTAINS / STARTS / ENDS	Convenient text operators
AND OR ( )	Combine and group conditions

SELECT, UPDATE, DELETE, INSERT, JOIN, functions, comments and subqueries are intentionally unsupported.

5. Natural language

Write the column name followed by a common instruction. Join conditions with AND/OR or their translated equivalents.

Puntos mayor que 100 y Subsidiary igual a ESP

Jugador empieza por Al o Jugador contiene Maria

Understood concepts: contains, does not contain, equals, different, starts with, ends with, greater/less than, at least/at most, is empty and is not empty.

6. Visual query builder

Choose a column, operator and value. Add as many AND/OR conditions as needed. Empty/not-empty operators do not require a value.

Back to help