About

FEEL is an expression language based on DMN specification conformance level 3. Written using PEG.js - JavaScript Parser Generator. FEEL is a very powerful language built with the purpose of defining rules in Business Rule Engines. FEEL also offers an API to implement and execute Decision Table defined in excel (.xlsx)

Getting Started

FEEL is a completely flexible library which can be used with any project to add support for Decision Table. It also comes with a powerful expression language termed FEEL built-in to define a multitude of decision rules.

Installation

Development

# npm install 
npm install js-feel --save
 

Contribution

# clone repo 
git clone https://github.com/EdgeVerve/feel.git
 
# or fork repo 
 
# install dependencies 
npm install
 
# run test cases 
npm test
 
# watch for changes in source and grammar 
gulp watch
 
# generate parser from grammar 
gulp generate
 
# lint source files 
npm run lint
 
# lint-fix source files 
npm run lintfix

Usage

Using Decision Table

Decision tables are defined in excel (.xlsx). Please check Sample Rules. Each cell in the body of the decision table has to be a valid FEEL expression. The following make use of FEEL parser to parse and execute expressions and hence the decision logic.

Excel to Decision Table

const { decisionTable } = require('feel')();
 
const csv = decisionTable.xls_to_csv('./test/StudentFinancialPackageEligibility.xlsx');
const decision_table = decisionTable.csv_to_decision_table(csv[0]);

Execute Decision Table

The Decision Table (decision_table) created in the previous step can be executed using; decisionTable.execute_decision_table

 
const payload = {"Student GPA" : 3.6,"Student Extra-Curricular Activities Count" : 4,"Student National Honor Society Membership" : "Yes"};
decisionTable.execute_decision_table("StudentFinancialPackageEligibility", decision_table,payload, (results)=> {
    console.log(results)
});

Using FEEL Standalone

const {feel} = require('feel')();
 
const rule = 'a + b - c';
const context = {
    a: 10,
    b: 20,
    c: 5
};
 
const parsedGrammar = feel.parse(rule);
parsedGrammar.build(context).then(result => {
    console.log(result);
}).catch(err => console.error(err));

Sample FEEL Expressions

Some valid FEEL expressions (logically categorized):

Arithmetic

• a + b - c
• ((a + b)/c - (d + e*2))**f
• 1-(1+rate/12)**-term
• (a + b)**-c
• date("2012-12-25") + date("2012-12-24")
• time("T13:10:06") - time("T13:10:05")
• date and time("2012-12-24T23:59:00") + duration("P1Y")

Comparision

• 5 in (<= 5)
• 5 in ((5..10])
• 5 in ([5..10])
• 5 in (4,5,6)
• 5 in (<5,>5)
• (a + 5) >= (7 + g)
• (a+b) between (c + d) and (e - f)
• date("2012-12-25") > date("2012-12-24")
• date and time("2012-12-24T23:59:00") < date and time("2012-12-25T00:00:00")

Conjunction

• a or b
• a and b
• ((a or b) and (b or c)) or (a and d)
• ((a > b) and (a > c)) and (b > c)
• ((a + b) > (c - d)) and (a > b)
• a or b or a > b
• (x(i, j) = y) and (a > b)
• (a + b) > (c - d) and (a > b)

For

• for a in [1,2,3] return a * a
• for age in [18..40], name in ["george", "mike", "bob"] return status

Function Definition

• function(age) age < 21
• function(rate, term, amount) (amount*rate/12)/(1-(1+rate/12)**-term)

If

• if applicant.maritalStatus in ("M", "S") then "valid" else "not valid"
• if Pre-Bureau Risk Category = "DECLINE" or Installment Affordable = false or Age < 18 or Monthly Income < 100 then "INELIGIBLE" else "ELIGIBLE"
• if "Pre-Bureau Risk Category" = "DECLINE" or "Installment Affordable" = false or Age < 18 or "Monthly Income" < 100 then "INELIGIBLE" else "ELIGIBLE"

Quantified

• some ch in credit history satisfies ch.event = "bankruptcy"

Date Time Semantics

• time("13:10:05@Etc/UTC").hour
• time("13:10:05@Etc/UTC").minute
• time("13:01:05+05:30").second
• date and time("2012-12-24T23:59:00").year
• date("2017-06-10").month
• date("2017-06-10").day
• duration("P13M").years
• duration("P1Y11M").months
• duration("P5DT12H10M").days
• duration("P5DT12H10M").hours
• duration("P5DT12H10M").minutes
• duration("P5DT12H10M25S").seconds

Date Time Conversion and Equality

• date("2012-12-25") – date("2012-12-24") = duration("P1D")
• date and time("2012-12-24T23:59:00") + duration("PT1M") = date and time("2012-12-25T00:00:00")
• time("23:59:00z") + duration("PT2M") = time("00:01:00@Etc/UTC")
• date and time("2012-12-24T23:59:00") - date and time("2012-12-22T03:45:00") = duration("P2DT20H14M")
• duration("P2Y2M") = duration("P26M")

Please note: This is not a complete list of FEEL Expressions. Please refer DMN Specification Document for detailed documentation on FEEL grammar.

Sample Rules

Validation.xlsx

PostBureauRiskCategory.xlsx

ElectricityBill.xlsx

Reference

For comprehensive set of documentation on DMN, you can refer to :

DMN Specification Document