Help - Search Bar

This application provides a table search utility that allows users to filter rows based on complex queries with support for logical operators (AND/OR) and column-specific searches. Below is an explanation of how to use the search functionality.

Features

Search Across All Columns: Enter a query to search across all table columns.
Column-Specific Search: Use square brackets ([index]) to limit searches to a specific column.
Logical Operators: Combine terms with AND or OR for more complex queries.
Highlight Matching Terms: Found terms are highlighted in the table for clarity.
Dynamic Query Parsing: The system supports advanced search patterns with regular expressions.
Case-Insensitive Matching: Searches are not case-sensitive.
Neighbor Expansion: Include rows above and below matching results for added context.

How to Use

Follow these simple steps to filter your table:

Enter Query: Type a search query into the input field with the desired syntax.
Set Neighbors (Optional): Use the "Neighbors" input field to specify how many rows above and below matching results should also be displayed.
Trigger Search: The filtering is applied immediately when you hit Enter.
Review Results: Matching rows, along with specified neighbors, remain visible, and matching terms are highlighted.

Search Syntax

Basic Search

Enter a keyword into the search bar to filter rows containing that term in any column.

Example:

word1

Column-Specific Search

To search in a specific column, use square brackets with the column index.

Example:

word1[2]

This searches for "word1" only in column 2 (column indices start at 0).

Logical Operators

Combine search terms using AND or OR. Note: Logical operators must be in uppercase.

Example 1:

word1 AND word2

This filters rows containing both "word1" AND "word2".

Example 2:

word1[1] OR word2[2]

This filters rows where "word1" appears in column 1 OR "word2" appears in column 2.

Neighbor Expansion

To include rows above and below matching results, specify the number of neighbors in the "Neighbors" input field.

Example:

Query: word1
Neighbors: 1

With this configuration, rows matching "word1" display along with one row above and one row below each matching row. If no number is specified in the "Neighbors" field, only the matching rows display.

Parentheses for Grouping

Use parentheses to group terms for more complex queries.

Example:

(word1 AND word2) OR word3