Skip to main content

​
Search Flow

diagram

​
Search Input

PropertyDescription
LocationEmbedded in the toolbar area
BehaviorFilters rows dynamically as the user types
Case sensitivityCase-insensitive
ScopeSearches across all visible columns

​
Search Highlighting

Matching text segments are highlighted within cells:
FeatureDescription
Highlight styleMatching text segments receive a highlight class
Multiple matchesEach match within a single cell gets a separate highlight span
Separate tokensEach word token in the search query may be highlighted separately
Match countThe total highlight count includes all visible matches across all matching rows
MethodDescription
Clear buttonClick the clear button next to the search input to restore all rows
KeyboardCtrl+A then Backspace clears the search text

​
Column Type Search Behavior

Search matches on the displayed text, not the underlying raw data:
Column TypeSearch Behavior
Text columnsStandard text matching on cell content
Reference columnsMatches on the display text of referenced entities (not internal IDs)
Custom renderer columnsMatches on the rendered output
Formatted numbersMatches on the formatted display string (e.g., $11,066), not the raw value
Search in columns with certain custom renderers may have limitations. Verify behavior for specific renderer types in your configuration.

​
Search Combined with Filters

Search operates on top of existing column filters:
InteractionBehavior
Column filter firstColumn filters reduce the row set
Search secondSearch applies only to rows passing column filters
Row count displayShows X/Y rows where X = search matches, Y = column-filtered row count
Independent clearClearing search restores the column-filtered view; clearing filters restores the pre-filter view

​
Search in Review Mode

Search integrates with review mode:
BehaviorDescription
Review filter applied firstReview mode reduces rows to only changed items
Search applied secondSearch further narrows within the review-filtered rows
Combined countRow count reflects the intersection of review filter and search

​
Filtered Rows Info

The filtered rows indicator appears when any filter (column filter, search, or review mode) is active:
DisplayMeaning
X/Y rowsX = visible rows after all filters; Y = total rows passing column filters (before search)
HiddenIndicator is not shown when all rows are visible
For reference columns (linked entities), additional search behavior applies:
FeatureDescription
Display text searchSearches the display label of referenced entities
Server-side searchWhen editing references, the dropdown searches the server for matching entities
list.search propertyConfigures which properties of referenced entities are searchable in picker dropdowns
columns:
  systemRequirements.systemRequirement:
    title: System Requirement
    display: title
    list:
      search:
        - title
        - id
PropertyTypeDefaultDescription
list.searcharraySee applicationArray of property names to search when filtering entities in picker dropdowns

​
Complete YAML Example

columns:
  id:
    title: ID
    width: 80
  title:
    title: Title
    width: "*"
    hasFocus: true
  severity:
    title: Severity
    width: 100
  systemRequirements.systemRequirement:
    title: Linked Requirement
    display: title
    list:
      search:
        - title
        - id

sortBy:
  - columnId: id
    direction: asc
Source: Search test specifications, reference test specifications, sheet component features
Source Code
  • prod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/cypress/e2e/Sheet/search.spec.ts
  • prod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/cypress/e2e/Sheet/reference.spec.ts
  • prod-powersheet-src/com.nextedy.powersheet.client/cypress/fixtures/configurations/constraints_composing.template.yaml
  • model.yaml
  • prod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/__tests__/odata-where-merger.test.ts