filter-data

filter-data

Description

Simple but fast data filter.

Examples

1. Example In Browser
2. Example In React

Benchmark

100 Records(ms)

*The results are little different in partial search.

	match-sorter (6.3.1)	fuse.js (6.6.2)	filter-data (0.2.0)
match all, 1 key	10.947ms	4.244ms	1.827ms
no match, 1 key	0.523ms	2.385ms	2.958ms
match partial, 1 key	0.232ms	0.318ms	2.475ms
match all, 2 keys	1.472ms	0.465ms	2.209ms
no match, 2 keys	0.188ms	0.513ms	2.522ms
match partial, 2 keys	0.191ms	0.318ms	2.475ms
match all, 1 key, slice(0,10)	0.192ms	0.206ms	0.388ms
no match, 1 key, slice(0,10)	0.101ms	0.317ms	0.079ms
match partial, 1 key, slice(0,10)	0.107ms	0.188ms	2.807ms
input empty	0.114ms	0.095ms	0.033ms

10000 Records(ms)

*The results are little different in partial search.

	match-sorter (4.0.2)	fuse.js (3.4.6)	filter-data (0.2.0)
match all, 1 key	21.439ms	49.336ms	16.884ms
no match, 1 key	18.239ms	33.312ms	6.382ms
match partial, 1 key	18.754ms	22.56ms	3.805ms
match all, 2 keys	22.815ms	22.524ms	10.416ms
no match, 2 keys	18.096ms	33.232ms	3.744ms
match partial, 2 keys	16.821ms	27.052ms	3.094ms
match all, 1 key, slice(0,10)	10.614ms	12.692ms	0.106ms
no match, 1 key, slice(0,10)	9.808ms	19.709ms	0.111ms
match partial, 1 key, slice(0,10)	9.593ms	16.094ms	0.393ms
input empty	10.571ms	6.985ms	0.03ms

Install From Browser

<script src="https://cdn.jsdelivr.net/npm/filter-data@0.2.0/dist/filterdata.min.js"></script>

Installation

filter-data is available as an npm package.

npm install --save filter-data

Usage

From Browser

import from FilterData object. And others are the same with From npm

const { filterData, SearchType } = FilterData;
.
.
.

From npm

1. search single key only.

   import { filterData, SearchType } from 'filter-data';
   
   // search firstName contains 'dan' and age < 20
   const searchConditions = [
     {
       key: 'firstName',
       value: 'dan',
       type: SearchType.LK,
     },
     {
       key: 'age',
       value: 20,
       type: SearchType.LT,
     },
   ];
   
   const result = filterData(data, searchConditions);
   // output:
   <!-- [
     { firstName: 'Daniel', age: 14 },
     { firstName: 'Dan', age: 18 },
   ] -->
   

2. search multiple keys.

   import { filterData, SearchType } from 'filter-data';
   
   // search firstName&lastName contains 'dan' and age < 20
   const searchConditions = [
     {
       key: ['firstName', 'lastName'],
       value: 'dan',
       type: SearchType.LK,
     },
     {
       key: 'age',
       value: 20,
       type: SearchType.LT,
     },
   ];
   
   const result = filterData(data, searchConditions);
   // output:
   <!-- [
     { firstName: 'Daniel', lastName: 'Johnson', age: 13 },
     { firstName: 'Jack', lastName: 'Danny', age: 19 },
   ] -->
   

3. caseSensitive.

   import { filterData, SearchType } from 'filter-data';
   
   // search firstName contains 'dan'
   const searchConditions = [
     {
       key: 'firstName',
       value: 'dan',
       type: SearchType.LK,
     },
   ];
   
   const result = filterData(data, searchConditions, { caseSensitive: true });
   // output:
   <!-- [
     { firstName: 'Jordan', age: 17 },
   ] -->
   

4. offset & limit.

   import { filterData, SearchType } from 'filter-data';
   
   // search firstName contains 'dan'
   const searchConditions = [
     {
       key: 'firstName',
       value: 'dan',
       type: SearchType.LK,
     },
   ];
   
   const result = filterData(data, searchConditions, { caseSensitive: true, offset: 10, limit: 10 });
   // output:
   <!-- [
     { firstName: 'Jordan', age: 17 },
     .
     .
     .
     max 10 records
   ] -->
   

5. search nested object.

   import { filterData, SearchType } from 'filter-data';
   
   // search firstName in father's sub object equals to 'dan'
   const searchConditions = [
     {
       key: 'father.firstName', // or key: [['father', 'firstName']]
       value: 'dan',
       type: SearchType.EQ,
     },
   ];
   
   const result = filterData(data, searchConditions);
   // output:
   <!-- [
     { firstName: 'Jordan', age: 17, father: { firstName: 'dan', age: 50 } },
   ] -->
   

Instructions

No.	Parameter	required	Default	Description
1	data	〇		array of object for filtering
2	searchConditions	〇		array of searchCondition; { key: 'search column', value: 'search value', type: 'search type' }
3	options		{ caseSensitive: false, includeNull: false, offset: undefined, limit: undefined }	includeNull: include data even key is not exist or value is null

SearchType

• SearchType.EQ: equal
• SearchType.GT: greater than
• SearchType.GTE: greater than or equal
• SearchType.LT: less than
• SearchType.LTE: less than or equal
• SearchType.LK: like
• SearchType.NE: not equal
• SearchType.NLK: not like

License

This project is licensed under the terms of the MIT license.

Changelog

0.6.1

Patch Changes

• #176 ea15c75 Thanks @renovate! - Updated dependency prettier to ^3.3.3.

• #177 72dc3da Thanks @renovate! - Updated dependency packageManager to pnpm@9.6.0. Updated dependency @swc/core to ^1.7.3. Updated dependency @types/node to ^20.14.13. Updated dependency @types/ramda to ^0.30.1. Updated dependency rimraf to ^5.0.9. Updated dependency tsx to ^4.16.3. Updated dependency typescript to ^5.5.4.

• #174 5a7f793 Thanks @renovate! - Updated dependency @changesets/cli to ^2.27.7.

• #179 6254e39 Thanks @renovate! - Updated dependency rimraf to ^6.0.1.

• #175 ca07b4a Thanks @renovate! - Updated dependency typescript to ^5.5.3.

• #183 ecaccc3 Thanks @renovate! - Updated dependency @types/node to ^20.16.3.

• #169 051d9c3 Thanks @renovate! - Updated dependency @types/node to ^20.13.0.

• #161 8020d74 Thanks @renovate! - Updated dependency packageManager to pnpm@8.15.8. Updated dependency ramda to ^0.30.0. Updated dependency @swc/core to ^1.4.17. Updated dependency @types/node to ^20.12.7. Updated dependency tsx to ^4.7.3. Updated dependency typescript to ^5.4.5.

• #165 27e7565 Thanks @renovate! - Updated dependency tsx to ^4.8.2.

• #182 f9c46eb Thanks @renovate! - Updated dependency packageManager to pnpm@9.9.0. Updated dependency @swc/core to ^1.7.22. Updated dependency @types/node to ^20.16.2. Updated dependency @types/ramda to ^0.30.2. Updated dependency tslib to ^2.7.0. Updated dependency tsx to ^4.19.0.

• #171 1230fad Thanks @renovate! - Updated dependency packageManager to pnpm@9.4.0. Updated dependency ramda to ^0.30.1. Updated dependency @changesets/cli to ^2.27.6. Updated dependency @swc/core to ^1.6.6. Updated dependency @types/node to ^20.14.9. Updated dependency tslib to ^2.6.3. Updated dependency tsx to ^4.16.0. Updated dependency typescript to ^5.5.2.

• #172 05b9f38 Thanks @renovate! - Updated dependency prettier to ^3.3.2.

• #181 6afcc91 Thanks @renovate! - Updated dependency @swc/core to ^1.7.5. Updated dependency @types/node to ^20.14.14.

• #166 280afe9 Thanks @renovate! - Updated dependency @types/node to ^20.12.8.

• #168 da04a25 Thanks @renovate! - Updated dependency @types/node to ^20.12.14.

• #164 1082acf Thanks @renovate! - Updated dependency packageManager to pnpm@9.0.6.

• #167 1f31cd5 Thanks @renovate! - Updated dependency packageManager to pnpm@9.1.4. Updated dependency @changesets/cli to ^2.27.5. Updated dependency @rollup/plugin-commonjs to ^25.0.8. Updated dependency @swc/core to ^1.5.24. Updated dependency @types/node to ^20.12.13. Updated dependency @types/ramda to ^0.30.0. Updated dependency rimraf to ^5.0.7. Updated dependency rollup-plugin-dts to ^6.1.1. Updated dependency tsx to ^4.11.0.

• #180 4e8dfd5 Thanks @renovate! - Updated dependency rimraf to ^5.0.10. Updated dependency tsx to ^4.16.5.

• #170 712ae6d Thanks @renovate! - Updated dependency prettier to ^3.3.0.

• #178 ba4d277 Thanks @renovate! - Updated dependency @swc/core to ^1.7.4.