Filter data with formula

filter-data-with-formula.js

// import filter function from formula library
var { filter } = require('formula');

// test data
let data = [
  { id: 1, name: 'Joe', data: [1, 2, 3] },
  { id: 2, name: 'Joe', data: [10, 20, 30], created: new Date() },
  { age: 1 },
  { age: 10 },
  { age: 100 },
];

// exec query and print results
function exec(...query) {
  var filteredRecords = filter(data, ...query);
  console.log("=========================================")
  console.log('Query = ', query);
  console.log('FilteredRecords =', JSON.stringify(filteredRecords, null, 4));
};

// simple rules
exec('age > 10');
exec('name = "Joe"');

// multiple rules requires all rules be true.
exec('age < 10', 'age > 0');

// check if field is date
exec('isDate(created)');

// any rule is true
exec('or( and( age < 5, age > 0), age > 20 )');

// check if field is empty
exec('isEmpty( age )');

// check if field is empty
exec('not(isEmpty( age ))');

// check if data has 1 or more items or characters
exec('len( if( data, data,  "" ) ) > 0');

// all rules must be true
exec('and( name = "Joe", isEmpty(created) )');