Synopsis

Potential usage scenarios

Usage as server - TypeScript

import{createFilter}from'odata-v4-mongodb'//example request:  GET /api/products?$filter=category/id eq 5 or color eq 'Red'app.get("/api/products",(req:Request,res:Response)=>{constfilter=createFilter(req.query.$filter);// collection instance from MongoDB Node.JS Drivercollection.find(filter,function(err,data){res.json({'@odata.context':req.protocol+'://'+req.get('host')+'/api/$metadata#products',value:data});});});

Usage ES5

varcreateFilter=require('odata-v4-mongodb').createFilter;app.get("/api/products",function(req,res){varfilter=createFilter(req.query.$filter);// collection instance from MongoDB Node.JS Drivercollection.find(filter,function(err,data){res.json({'@odata.context':req.protocol+'://'+req.get('host')+'/api/$metadata#products',value:data});});})

Supported OData segments

Supported $filter expressions

√ expression 5.1.1.6.1: NullValue eq null√ expression 5.1.1.6.1: TrueValue eq true√ expression 5.1.1.6.1: FalseValue eq false√ expression 5.1.1.6.1: IntegerValue lt -128√ expression 5.1.1.6.1: DecimalValue eq 34.95√ expression 5.1.1.6.1: StringValue eq 'Say Hello,then go'√ expression 5.1.1.6.1: DurationValue eq duration'P12DT23H59M59.999999999999S'√ expression 5.1.1.6.1: DateValue eq 2012-12-03√ expression 5.1.1.6.1: DateTimeOffsetValue eq 2012-12-03T07:16:23Z√ expression 5.1.1.6.1: GuidValue eq 01234567-89ab-cdef-0123-456789abcdef√ expression 5.1.1.6.1: Int64Value eq 0√ expression 5.1.1.6.1: A eq INF√ expression 5.1.1.6.1: A eq 0.31415926535897931e1√ expression 5.1.1.1.2: A ne 1√ expression 5.1.1.1.3: A gt 2√ expression 5.1.1.1.4: A ge 3√ expression 5.1.1.1.5: A lt 2√ expression 5.1.1.1.6: A le 2√ expression: A/b eq 1√ expression 5.1.1.3: (A/b eq 2) or (B/c lt 4) and ((E gt 5) or (E lt -1))