Results for “Lists & filtering”
Small, practical examples. Search by task or narrow things down below.
Keep parent rows while filtering joined children
Postgres: Put a child filter in ON when unmatched parents must remain in the result.
Postgres✓ Tested
Keep parent rows while filtering joined children
SQLite: Put a child filter in ON when unmatched parents must remain in the result.
SQLite✓ Tested
Represent a hierarchy with nested lists
HTML: Place the nested list inside its parent list item to preserve the hierarchy.
HTML✓ Tested
Require two filtering conditions
SQL: Combine category and quantity conditions with AND.
SQL✓ Tested
Require two filtering conditions
SQL Server: Combine category and quantity conditions with AND.
SQL Server✓ Tested
Require two filtering conditions
Postgres: Combine category and quantity conditions with AND.
Postgres✓ Tested
Require two filtering conditions
SQLite: Combine category and quantity conditions with AND.
SQLite✓ Tested
Separate records into two lists
Python: Build two explicit partitions so callers can use both matching and rejected values.
Python✓ Tested
Bind a narrowed value using an @if alias
Bind a narrowed value using an @if alias with a standalone Angular component and explicit browser behavior.
Angular✓ Tested
Expose the current index in @for
Expose the current index in @for with a standalone Angular component and explicit browser behavior.
Angular✓ Tested
Filter a signal-backed list
Filter a signal-backed list with a standalone Angular component and explicit browser behavior.
Angular✓ Tested
Page through a collection
Page through a collection with a standalone Angular component and explicit browser behavior.
Angular✓ Tested