Browse Prior Art Database

Contextual instant filtering of data table Disclosure Number: IPCOM000236456D
Publication Date: 2014-Apr-28
Document File: 3 page(s) / 125K

Publishing Venue

The Prior Art Database


Disclosed is an enhancement to user interfaces that show large tables or lists of data records. The enhancement allows user to conveniently filter displayed data to see data records similar to a particular selected data record.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 52% of the total text.

Page 01 of 3

Contextual instant filtering of data table

There are a lot of computer programs where data is presented visually in a some form of a table, matrix or spreadsheet. In fact, using computer to present and manage data is the core of Information Technology. In order for such UI to be usable with large volume of data, there has to be a way to filter or search through the data rows to get relevant information faster. There are many approaches available in modern user interfaces,

which address various use cases, such as keyword or fulltext search box, column sorting, or auto filter which allows to filter on data from each column using a drop-down menu.

In this disclosure there is a focus on the following use case: user is working with a data row and would like to find all similar rows, with same data in most columns. In a real

world scenario the table could contain list of computer systems. If there is a problem

reported with a particular system user may need to find systems with same specification except for hostname or other unique attributes.

This goal can be achieved currently by using filtering (known in spreadsheet software as Instant Filter in Lotus Symphony or AutoFilter in MS Excel) and manually assigning desired value to filter on each column. This approach may work conveniently with a small amount of data. In such case perhaps even filtering on one column may be sufficient. With a growing volume and complexity of data it may require more steps by the user to get to desired data.

The approach presented in this document makes filtering more convenient when dealing with large volume of data.

   There are a few known solutions for multi column filtering:
• It is possible to make multi column autofilters in Excel but it is complicated, non intuitive and time consuming:

Excel Advanced Filter Introduction (http://www.context...