Inforiver
EDITable
EDITable
  • Introduction to EDITable
    • Why EDITable?
    • Supported Database Connections
  • Get Started
    • EDITable Pre-requisites
      • Admin consent for EDITable's Entra ID
        • Basic consent
        • Full admin consent
    • Install EDITable
    • Add EDITable visual
  • Getting Data into EDITable
    • Connect to Data
      • Get data
      • Assign fields
      • Configuration Steps
        • Configure source
        • Configure Columns
        • Configure Type 2 SCDs (Optional)
    • Create a Table
      • Create From Scratch
      • Use Existing Table
      • Import Data
  • Working with EDITable
    • EDITable interface
    • Manage Columns
      • General
      • Constraints
      • Lookup and Relation
      • Display
      • Import/Export Configuration
      • Add Database Column
      • Insert Column
    • Column Access Control
    • Row Identification
    • Table Operations (Insert/Update/Delete)
      • Edit data
      • Bulk Edit
      • Find and Replace
      • Insert rows
      • Insert Column
      • Import rows
      • Delete rows
      • Duplicate rows
      • Copy rows
      • Preview Changes
      • Reset Changes
    • Explore data
      • Search and filter
      • Sort and reorder
      • Show/Hide columns
      • Pin columns
      • Group Rows By
      • Summarize Column
    • Basic formatting
    • Conditional Formatting
  • Row Access Control
  • Approval Workflow
    • Review Changes - Workflow process
  • Type 2 SCDs
    • Configuring Type 2 SCDs in EDITable
  • Audit logs
  • Webhook
  • Display Settings
  • Commenting and Collaboration
    • Assign users & task status
    • View all comments & track changes
    • Comment Settings
  • Admin Portal & EDITable Console
    • Tables
    • Transaction Logs
    • Insights (Metrics)
    • Utility
      • Download Report
      • Pipeline
        • Power BI & EDITable deployment pipelines
        • Deployment in different destinations
        • Trigger deployment pipeline from external applications
        • Logs & other pipeline options
    • Manage Profile
    • Admin Portal
      • User Management
      • Settings
        • General Settings
        • Writeback Settings
          • Settings
          • EDITable managed DB
        • API token
    • Onboarding Actions
  • Formula and Functions
    • Conditional statements
      • IF
      • IFNA
      • SWITCH
    • Logical functions
      • AND
      • IN
      • ISBLANK
      • ISEMPTY
      • ISNUMBER
      • NOT
      • OR
      • XOR
    • Math functions
      • ABS
      • AVERAGE
      • AVERAGEIF
      • AVERAGEEXNEG
      • AVERAGEEXZERO
      • AVERAGEEXZERONEG
      • CEILING
      • COUNT
      • COUNTIF
      • DIVIDE
      • EVEN
      • EXP
      • FLOOR
      • LOG
      • MAX
      • MIN
      • PCT
      • POWER
    • Text formatting functions
    • Date functions
      • DATE
      • DATE.FORMAT
    • Other operators
  • Keyboard Shortcuts
  • Release Notes
    • EDITable - v1.7.5
    • EDITable - v1.7
    • EDITable - v1.6.5
    • EDITable - v1.6
Powered by GitBook
On this page
  • 1. Search
  • 2. Filter
  • 2.1. Nested and grouped filters
  • 2.2. Column-level filter
  1. Working with EDITable
  2. Explore data

Search and filter

PreviousExplore dataNextSort and reorder

Last updated 9 months ago

We will now explore the various options in EDITable for searching and filtering data. These options allow you to analyze data in chunks, especially when dealing with a large volume of data.

1. Search

The Search option allows you to quickly locate specific records in your table by entering characters, words, numbers, or phrases. EDITable displays all records containing the entered character, number, or text.

  1. In the 'Home' tab of the toolbar, click on the 'Search' icon.

  1. Type the character/text in the search box. EDITable starts narrowing down the matches as soon as you start typing. Navigate through the results using the up and down arrows.

  1. You can also search for numeric values as shown in the below image.

EDITable searches across pages if the table spans over multiple pages.

2. Filter

EDITable provides nested AND/OR filtering options to filter a range of data based on the criteria you define.

2.1. Nested and grouped filters

Nested filters

  1. In the 'Home' tab of the toolbar, click on the 'Filter' icon.

  1. Click Add Filter. Based on the column selected, different conditions are provided. You can select a condition as shown below.

  1. In the example below, the data has been filtered based on the job title.

  1. You can add multiple filters using the Add Filter option and apply nested AND/OR conditions. In the example below, we have added one more condition to filter only those with salaries greater than 180000 for the given job title. Both conditions have been combined using the AND operator.

Grouped filters

  1. You can also organize multiple filters into filter groups. Click Advanced.

  1. Click Add group to add another group. In the below example, we have added four conditions nested using AND/OR and using two filter groups. The filtered table is also shown.

  1. You can delete the individual filters by clicking on the 'Delete' icon available next to the condition.

  2. The Persist filters option ensures the filters are retained when switching between pages in the visual.

  3. Click on Reset All to reset all the filters.

2.2. Column-level filter

EDITable provides both basic and advanced column-based filtering options to filter specific data or a range of data based on the criteria you define.

  1. When you mouse over any column, a three-dot menu appears as highlighted. Click on it and then select the 'Filter' icon.

  1. You can do basic filtering by selecting the required data from the drop-down list.

  1. You can also apply advanced filtering based on specific criteria. Click on the 'Advanced filter' icon to specify the condition. The displayed conditions vary based on the column selected. In the example below, we filtered the employees whose salaries exceeded 100k.

  1. You can add nested AND/OR filters by clicking the Add rule option. In the below example, we have added one more condition - 'less than 200k'. All employees whose salaries range between 100k and 200k are displayed.

Click Clear filter beside the required filter to clear it or click Clear All to clear all the column filters applied.

'Search' option
Search record using text
Search for numeric values
'Filter' option
Add filter
Filter results
Nested filter
Advanced filter
Group filters
Delete, Reset, Persist filters
Column filter
Basic column filter.
Advanced filter
Nested column filter